Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert a column of numbers into comma separated values . | Excel Worksheet Functions | |||
parse comma separated text to multiple cells and remove duplicates | Excel Worksheet Functions | |||
HOW TO | *automatically* parse comma separated text to multiple ce | Excel Discussion (Misc queries) | |||
combine rows into one cell separated by comma | Excel Discussion (Misc queries) | |||
Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) |