Importing CSV data

M

Mellstock

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
 
D

Dallman Ross

In <[email protected]>,
Mellstock said:
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-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top