csv conversion

  • Thread starter Thread starter Rozman
  • Start date Start date
R

Rozman

How can i break apart a comma delimited text string in a single cell to
multiple cells based on comma loaction?
 
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
 
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
 
Back
Top