Text to columns

[Guest]

Hi

I was pasting information from another source into excel. The problem is
that I am pasting numbers separated by a comma ",". The problem is that
there are like 2000 numbers and when I do "Text to Columns" most of the
numbers are cut off, because there are only like 360 columns in excel. Is
there any solution to this problem?

Thanks for your help

 

[Frank Kabel]

Hi
you have to split your data. 256 columns is the max in Excel

 

[Jay]

I was pasting information from another source into excel. The

you have to split your data. 256 columns is the max in Excel

One way to split your data is to open the file first in Word. In Word,
replace comma by "Paragraph mark" everywhere. Then save as a text file.

Now when you open the file in Excel there'll be one column and 2000 rows.
While this might not be what you want, at least it's a starting point with
all the numbers preserved.