Help needed from Excel Pros

Cubswin · #1 08-04-2006, 03:18 PM

Im really drawing a blank here... hopefully someone knows how to do this. I have a column of data in Excel that I need to get into a string of text seperated by a semi-colons. For example, my data in Excel looks like this:

column A
1234
2345
4567
4820
3783

and I want the data to look like this (in text format):

1234;2345;4567;4820;3783

One big thank you to the person that knows how to do this.

Thanks in advance for the help!!!
cubs

Evan · #2 08-04-2006, 03:20 PM

copy data
paste special
transpose
copy transposed data to notepad
use find replace to put in semicolons

edit: highlight the space between the numbers and copy/paste that into the "find" box

JasonK · #3 08-04-2006, 03:20 PM

=CONCATENATE(A1,";",A2,";",) etc down the column

RayPowers · #4 08-04-2006, 03:21 PM

Can't copy,paste special, transpose, then save as comma delimited and just search and replace the , for ;?

Ray

Evan · #5 08-04-2006, 03:23 PM

[ QUOTE ]
=CONCATENATE(A1,";",A2,";",) etc down the column

[/ QUOTE ]
This is an early frontrunner for slowest possible way to do this.

econophile · #6 08-04-2006, 03:24 PM

here's my excel tip: F4

offTopic · #7 08-04-2006, 03:29 PM

[ QUOTE ]
copy data
paste special
transpose
copy transposed data to notepad
use find replace to put in semicolons

edit: highlight the space between the numbers and copy/paste that into the "find" box

[/ QUOTE ]

While this most likely works 100%, I think we need to get this validated by DcifrThis, as he has been previously handsomely compensated for "Excel centered responsibilities".

RayPowers · #8 08-04-2006, 03:31 PM

Evan did you totally hax your post to take my idea?

Ray

Evan · #9 08-04-2006, 03:34 PM

[ QUOTE ]
Evan did you totally hax your post to take my idea?

Ray

[/ QUOTE ]
No, but I was going to ask if you looked at my post first to come up with a slightly less efficient version of the same thing? [img]/images/graemlins/grin.gif[/img]

Evan · #10 08-04-2006, 03:35 PM

[ QUOTE ]
[ QUOTE ]
copy data
paste special
transpose
copy transposed data to notepad
use find replace to put in semicolons

edit: highlight the space between the numbers and copy/paste that into the "find" box

[/ QUOTE ]

While this most likely works 100%, I think we need to get this validated by DcifrThis, as he has been previously handsomely compensated for "Excel centered responsibilities".

[/ QUOTE ]
I feel like I'm missing something. Is this a reference to a thread?