Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV all in one column problem
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) -- Rich http://www.richdavies.com/football-pools.htm http://www.richdavies.com/slow-cooker-recipes.htm |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV all in one column problem
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???). " wrote: 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) -- Rich http://www.richdavies.com/football-pools.htm http://www.richdavies.com/slow-cooker-recipes.htm -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV all in one column problem
Hi,
In 2007 the technique is the same as in 2003, but it is located on the Data tab. -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: 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) -- Rich http://www.richdavies.com/football-pools.htm http://www.richdavies.com/slow-cooker-recipes.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text-to-column problem | Excel Discussion (Misc queries) | |||
what is the problem, when value comes up in the total column | Excel Worksheet Functions | |||
Column Problem Help Please! | Excel Worksheet Functions | |||
Column searching problem | New Users to Excel | |||
Column Header Problem | Excel Worksheet Functions |