Comma Deleted File into Excel doc

  • Thread starter Thread starter MarkAC
  • Start date Start date
M

MarkAC

I have recieved a comma deleted file which I need to save as an excel
doc. Having opened it with excel all the data in shown in the first
column. There are several columns of info.

I have tried to format the text to no avail.

Line Example, 3040, 3040, -1, -1, -1

How can I get this into 5 columns instead of one.

Thanks in advance.

Mark
 
Hi,

Try Data->Import External Data-> Import Data

Follow the wizard, and as delimiter char set comma ","

It should help !

Br,
Andis
 
You must log in or register to reply here.

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

Similar Threads

.csv Commas ? 2
Auto Filter Comma Dilemiation 2
create macro - delete all rows with zero in column L 2
All functions that use commas aren't working! 1
Returning multiple text data into 1 column from many column entrie 1
Match and delete rows on two different sheets from reference numbers 4
Which is the best MBOX Converter Tool different formats conversion? 5
concatenate won't work 6

Back
Top