Running Out of Room Pasting

[Guest]

Hi

I am copying some numbers from another source into excel. The numbers are
separated by a comma. there are like 1500 numbers.

The problem is that when these are copied into excel I use text to columns,
but since there are 1500 and only like 300 columns in excel the extra numbers
are cut off.

Is there any way to fix this problem and keep all the numbers?

Thanks

 

[Guest]

hi
a suggestion.
use text to columns fixed width to cut the string of
numbers in to 10 groups. copy 9 of the groups to different
rows or sheets. the use text to columns comma dilimited on
each group.

 

[Dave Peterson]

Another option:

copy your numbers
but paste into MSWord
ctrl-a to select all the document
edit|replace
What: , (comma)
with: ^p (shift-6, p)

Replace all.

Now pick up all that data (no more than 64k, though) and paste into excel.

^p is the paragraph mark in MSWord.