Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv conversion
How can i break apart a comma delimited text string in a single cell to
multiple cells based on comma loaction? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv conversion
Select the column of values and use Data | Text to Columns, specify
Delimited and check the Comma box But first make sure there are enough blank columns to the right to accept the new values best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Rozman" wrote in message ... How can i break apart a comma delimited text string in a single cell to multiple cells based on comma loaction? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
csv conversion
Use the "text to columns" feature. First, highlight the range of CSV
data. Then, on the Excel menu, click Data Text to Columns. Select the "Delimited" radio button and click Next; select the "Comma" box, deselect the other choices, and click Next; use the Advanced Features if you want, or click Finish. Dave O Eschew obfuscation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion help | Excel Worksheet Functions | |||
conversion help | Excel Discussion (Misc queries) | |||
CONVERSION | Excel Discussion (Misc queries) | |||
pdf conversion | Excel Worksheet Functions | |||
Between conversion | Excel Worksheet Functions |