Text to columns

J

Jeff

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
 
J

Jay

I was pasting information from another source into excel. The
you have to split your data. 256 columns is the max in Excel
Click to expand...

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.
 
Top