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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Puzzling quotes around text 2
how do I change a csv extension file to an xls file and use it? 1
*.csv format change if .xlt save as .csv in Excel 2007 1
csv files 1
Open CSV file auto delimites using space not comma 2
Save as CSV: extra spaces around commas 2
.csv Commas ? 2
Format changed if we save our own (.xlt) file as (.csv) in Excel 2 1

Back
Top