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

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

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

Use Data/ Import External Data/ Import Data, specify as delimited, then set
the delimiter to whatever the delimiting character in your csv file is.
--
David Biddulph

"Dima" wrote in message
...
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

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

Thanks David for replying!
I tried before the Data/Import External Data/Import Data, specified as
delimited, then set the delimiter.
Excel 2003 also scrambles the data ending with symbols.
Best regards,
Dmitry
"David Biddulph" wrote:

Use Data/ Import External Data/ Import Data, specify as delimited, then set
the delimiter to whatever the delimiting character in your csv file is.
--
David Biddulph

"Dima" wrote in message
...
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

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

So what character is in the file?
--
David Biddulph

"Dima" wrote in message
...
Thanks David for replying!
I tried before the Data/Import External Data/Import Data, specified as
delimited, then set the delimiter.
Excel 2003 also scrambles the data ending with symbols.
Best regards,
Dmitry
"David Biddulph" wrote:

Use Data/ Import External Data/ Import Data, specify as delimited, then
set
the delimiter to whatever the delimiting character in your csv file is.
--
David Biddulph

"Dima" wrote in message
...
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

Excel 2003 unites csv file row contents in a column A withsquares
 

On Aug 19, 3:29 am, Dima wrote:
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

It sounds like a font incompatibility. The squares often show up when
you try to use a symbol from one font in a different font that doesn't
have that symbol. So it just defaults to a square. And then I would
guess Excel 2003 isn't recognizing that symbol for doing a delimited
import from csv.

It works properly for me, with Outlook 2003 and Excel 2003. Perhaps
going from a 2007 address book to 2003 is a problem?

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

Thanks David for replying!
Some letters are cyrillic.
The symbols with which Excel 2003 replaces the ending are meaningless.
Regards,
Dmitry
"David Biddulph" wrote:

So what character is in the file?
--
David Biddulph

"Dima" wrote in message
...
Thanks David for replying!
I tried before the Data/Import External Data/Import Data, specified as
delimited, then set the delimiter.
Excel 2003 also scrambles the data ending with symbols.
Best regards,
Dmitry
"David Biddulph" wrote:

Use Data/ Import External Data/ Import Data, specify as delimited, then
set
the delimiter to whatever the delimiting character in your csv file is.
--
David Biddulph

"Dima" wrote in message
...
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

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

Thanks Spiky for replying!
The address book was exported to csv in Windows Vista, not 2007.
How to resolve the font incompatibility?
Regards,
Dmitry
"Spiky" wrote:

On Aug 19, 3:29 am, Dima wrote:
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

It sounds like a font incompatibility. The squares often show up when
you try to use a symbol from one font in a different font that doesn't
have that symbol. So it just defaults to a square. And then I would
guess Excel 2003 isn't recognizing that symbol for doing a delimited
import from csv.

It works properly for me, with Outlook 2003 and Excel 2003. Perhaps
going from a 2007 address book to 2003 is a problem?

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

On Aug 19, 11:42 am, Dima wrote:
Thanks Spiky for replying!
The address book was exported to csv in Windows Vista, not 2007.
How to resolve the font incompatibility?
Regards,
Dmitry

"Spiky" wrote:
On Aug 19, 3:29 am, Dima wrote:
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

It sounds like a font incompatibility. The squares often show up when
you try to use a symbol from one font in a different font that doesn't
have that symbol. So it just defaults to a square. And then I would
guess Excel 2003 isn't recognizing that symbol for doing a delimited
import from csv.

It works properly for me, with Outlook 2003 and Excel 2003. Perhaps
going from a 2007 address book to 2003 is a problem?

Well, I don't have Vista. Or 2007. So I don't really know anything
about Windows Address Book.

But what you can do is go into one of those cells and highlight & copy
the offending character. Then go into Text to Columns:Delimited and
you'll be able to paste the character in so you can spread the info to
columns.

Or, since you can import this easily to Excel 2007, wouldn't it be
possible to use that, then save it? That should allow Excel 2003 to
open it, I would think. This may also be useful, it seems to work:
http://www.microsoft.com/downloads/d...displaylang=en

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

Thanks Spiky for replying!
What program can I use to open a csv file correctly except Excel 2007?
Regards,
Dmitry
"Spiky" wrote:

On Aug 19, 11:42 am, Dima wrote:
Thanks Spiky for replying!
The address book was exported to csv in Windows Vista, not 2007.
How to resolve the font incompatibility?
Regards,
Dmitry

"Spiky" wrote:
On Aug 19, 3:29 am, Dima wrote:
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

It sounds like a font incompatibility. The squares often show up when
you try to use a symbol from one font in a different font that doesn't
have that symbol. So it just defaults to a square. And then I would
guess Excel 2003 isn't recognizing that symbol for doing a delimited
import from csv.

It works properly for me, with Outlook 2003 and Excel 2003. Perhaps
going from a 2007 address book to 2003 is a problem?

Well, I don't have Vista. Or 2007. So I don't really know anything
about Windows Address Book.

But what you can do is go into one of those cells and highlight & copy
the offending character. Then go into Text to Columns:Delimited and
you'll be able to paste the character in so you can spread the info to
columns.

Or, since you can import this easily to Excel 2007, wouldn't it be
possible to use that, then save it? That should allow Excel 2003 to
open it, I would think. This may also be useful, it seems to work:
http://www.microsoft.com/downloads/d...displaylang=en

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

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.