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-
|