Excel 2003 unites csv file row contents in a column A with squares

D

Dima

Hello!
I exported a Windows Address book to a csv file in Windows Vista. Excel 2007
opens the file correctly, but Excel 2003 unites row contents in a column A
with squares betweel fields.
How to open the csv file in Excel 2003 correctly?
Regards,
Dmitry
 
S

Spiky

Try Word. Perhaps you can look and see if it really looks like commas
in between each bit of data. If you can identify some problem
character, you should be able to do a Replace in Word and change them
all into commas. Then it should open properly in any version of Excel.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV File Opening Conversion Issue 1
.csv Commas ? 2
Openig CSV file format with Excel in Office 2007 1
Save as CSV not saving the same from Excel 2007 then in Excel 2003 1
CSV File Will Not Open Directly in Excel 2003 4
Changing a csv file opened as hidden workbook 13
How do I download and open a CSV file in Excel 2000? 1

Top