Multiple numbers in a cell separated by a comma, need separate cel
 

Multiple numbers in a cell separated by a comma, need separate cells. Is
ther a way to take the contents of cell A1 (contains: 192410, 192413, 90704,
....) and "separate" the data to individual cells (without entering manually)?

Thanks.

Multiple numbers in a cell separated by a comma, need separate cel
 

Use text to columns facility. Works even when data is not text. Paste data
into A1 then highlight extent of data just in col A. Hit text to columns.
Chose delimited. Next. Delimiters comma (uncheck others). This should now
have appearance of columns. Next. Format cols as general. Finish.

Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Ozzie90680" wrote:

Multiple numbers in a cell separated by a comma, need separate cells. Is
ther a way to take the contents of cell A1 (contains: 192410, 192413, 90704,
...) and "separate" the data to individual cells (without entering manually)?

Thanks.