| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I de-concatenate items separated by commas!
How would I take a list of items separated by commas in a field and make each
item its own field (column or row)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I de-concatenate items separated by commas!
Hi,
data|Text to Columns Follow the wizard and use a comma delimeter Mike "Taneli Hanhivaara" wrote: How would I take a list of items separated by commas in a field and make each item its own field (column or row)? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I de-concatenate items separated by commas!
Try Data Text to Columns, delimited comma
-- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:365 Subscribers:65 xdemechanik --- "Taneli Hanhivaara" wrote: How would I take a list of items separated by commas in a field and make each item its own field (column or row)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can Enter Page Numbers and/or page ranges separated by commas. | Excel Discussion (Misc queries) | |||
| CONCATENATE on separated values | New Users to Excel | |||
| Help! I need a formula to add numbers separated by commas within | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Concatenate columns, separated by double quotes | Excel Worksheet Functions | |||
Linear Mode
