Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 unites csv file row contents in a column A with squares | Excel Discussion (Misc queries) | |||
Get rid of small squares in column | Excel Discussion (Misc queries) | |||
Excel 2003 - Counting Contents of Cells | Excel Discussion (Misc queries) | |||
How do I convert a Excel 2003 file into a Word 2003 file (table)? | Excel Discussion (Misc queries) | |||
removing squares and lines in squares that really should be paragr | Excel Discussion (Misc queries) |