Hi Tom, you need to use Data Text to Columns wizard. Use "delimited" and
assign the comma as the seperator, this will automatically split the data at
the commas and push them over in the columns as far as they need to go for
each cell.

HTH,

Kevin M
MOS Excel Specialist

"lehigh46" wrote:


Hi All,

I have copied a small sample of a spread sheet which contains the
following numbers and they resides in column A.

562111
541512
42149, 42184, 42212, 42213
323122, 323114, 541922
541512, 541519
423810, 424990, 423820, 424690, 532412
236210, 236220, 237110, 237310, 237990, 541330, 541380
56291, 56121, 23816, 23891
54191, 541611, 54163
524210
541614

I would like to seperate the numbers into columns B, C, D, E, and so
on, starting with the first number in column B.

Notice that the numbers are not all the same length.

Can anyone tell me how I can accomplish this?



Thanks for your help


Tom Snyder






x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD