Importing CSV data
 

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.

Thank you

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-