CSV all in one column problem

  • Thread starter Thread starter richdaviesdotcom
  • Start date Start date
R

richdaviesdotcom

Hi,

I have a comma delimited CSV file, listing firstname, surname,
address
line1, town, county, age etc

When I open in Excel, all the records appear in column A. What's the
easiest way for end up with firstname in A, surname in B etc ?
(There's
over 10,000 records)
 
After you import the data into column A, you can select column A, then use
Data|text to columns (xl2003 menus).

Choose delimited and specify your separator (a comma???).
 
Hi,

In 2007 the technique is the same as in 2003, but it is located on the Data
tab.
 
Back
Top