Prev: Custom filling of cells
Next: Lost arrow functionality within Excel
From: Ozzie90680 on 4 Mar 2010 20:52
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.
From: Russell Dawson on 4 Mar 2010 21:07
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.
 | 
Pages: 1
Prev: Custom filling of cells
Next: Lost arrow functionality within Excel