View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dallman Ross Dallman Ross is offline
external usenet poster
 
Posts: 390
Default Importing CSV data

In . com,
Mellstock spake thusly:

My bank can send me my account details to a spreadsheet (download
details to spread sheet). It comes into in my case excel as
presumably a csv flie as the data is put into the spreadsheet a
reading from left to right sperated by commas.

What do I need to do to get this raw data into sperate cells /
columns.


Select Column A; then go to the Menu Bar. Select Data -
Text to Columsn, and follow the prompts from the Text-to-
Columns Wizard. E.g., delimited fields, using commas
as the delimiter . . .

-dman-