Thread: Convert Excel Column to text file seperated by commas

Hello,

I am receiving data in excel 2003 that I am needing to convert to a text format.

The data in excel is oriented in a single column and is over 5 thousand items in length. I need make this data accessible in a work processor such that the items are oriented horizontally and are separated by commas.

I have attempted to utilize the special paste-transpose feature and save the file as comma delineated, unfortunately excel will not allow this as the ttl columns allowed is under 260 and it will not auto wrap onto the next row.

A condensed example below.

Excel shows:
111
123
124
134

I need it displayed:
111,123,124,134.... (over five thousand items long)

Any help would be greatly apprieciated.

Thx

isn't there a 256 character limit in one cell?

Sorry for the confusion. the column has over 5 thousand cells with individual numbers in each of them.

Thx

ok you need word for this
in excel
copy column then paste special /unformatted text into word
you'll now have loads of data in a column

now select all
use edit/replace just as excel
in find what put ^p (this is the paragraph mark from the find special list)
in replace put ,
then replace all

data should now change from
123
456
789
345
to 123,456,789,345,
select all /copy/paste to notepad

Martin - Thank you very much for the assistance. Your steps worked just as you advised they would.

I have kind of a simular problem. I needed to edit a TXT file with a string of rows & columns.
For Example:
L 565.0000, 1364.0000, 28.0000, 566.0000, 1361.0000, 28.0000, 190, 190, 190
L 566.0000, 1361.0000, 28.0000, 638.0000, 1362.0000, 28.0000, 190, 190, 190

Those are just the first two lines. Using Excel's text to columns to seporate by space & commas.
That I might edit only the columns I wanted, with out having to go through the text file editting over 500 lines of text on only some lines with the values I wanted to change, while skipping ones I did not.

For Example:
L 565.0000, 1364.0000, 28.0000, 566.0000, 1361.0000, 28.0000, 190, 190, 190
L 566.0000, 1361.0000, 28.0000, 638.0000, 1362.0000, 28.0000, 190, 190, 190

L 565.0000, 1364.0000, 28.0000, 566.0000, 1361.0000, 28.0000, 0, 0, 0
L 566.0000, 1361.0000, 28.0000, 638.0000, 1362.0000, 28.0000, 0, 0, 0

My question is how would I undo the "Text to columns"? For each [space] is now a [tab] when trying to save back to text file.
I did try the above, but it only works for the first column of cells. Ends up looking like this:

L [tab] -60.0000 [tab] -1.0000 [tab] 7.0000 [tab] -56.0000 [tab] 18.0000 [tab] 8.0000 [tab] 0 [tab] 0 [tab] 0,L[word wrap to new line] [tab] -56.0000 [tab] 18.0000 [tab] 8.0000 [tab] -46.0000 [tab] 36.0000 [tab] 7.0000 [tab] 0 [tab] 0[word wrap to new line] [tab] 0,L [tab] (ect...)
(the "spacing" does not show up exactly the same in post)