Exporting Outlook Contacts to Excel results in data loss from contact notes (Office 2003, Win/XP)

  • Thread starter FSOphof
  • Start date Views 825
Status
Not open for further replies.
F

FSOphof



Only the first 245 - 246 characters of notes (including spaces) show up in the Excel file.
I don't know whether Outlook only exports that amount, or that Excel has an upper limit per field.
Is this a known problem? If so, what is the solution--other than reducing the note-size?
If not, where do I post this bug?

Regards,
Scott
 
P

Pollardie

I too have the same probelm it only exports 246 characters, its not an issue with outlook. However its the excel limit of characters per cell.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
I too have the same probelm it only exports 246 characters, its not an issue with outlook. However its the excel limit of characters per cell.

From http://office.microsoft.com/en-us/excel/HP051992911033.aspx
Column width 255 characters Row height 409 points Page breaks 1000 horizontal and vertical Length of cell contents (text)

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.


It's more likely a limitation in the export translator - it has not been updated - ever - and could be stuck on Excel97 or earlier limitations. Export to CSV and open in Excel 2010 works (it might not in 2003, but I don't have 2003 handy to check.)

 
F

FSOphof



From http://office.microsoft.com/en-us/excel/HP051992911033.aspx
Column width 255 characters Row height 409 points Page breaks 1000 horizontal and vertical Length of cell contents (text)

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.


It's more likely a limitation in the export translator - it has not been updated - ever - and could be stuck on Excel97 or earlier limitations. Export to CSV and open in Excel 2010 works (it might not in 2003, but I don't have 2003 handy to check.)


Subscribe to Exchange Messaging Outlook weekly newsletter
Thank you! FYI, opening a CSV in Excel 2003 works fine (I tried it). No data-loss detected; my notes are nowhere near 32 KB....
BUT... I prefix certain data with hyphens, like "-AND", to quickly find my contact-info on Anderson Airport), and this results in the Excel error "#NAME?". And I can't find a way to avoid that errormsg. (sigh: some days it jes' ain't worth gettin' up)
Scott
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
BUT... I prefix certain data with hyphens, like "-AND", to quickly find my contact-info on Anderson Airport), and this results in the Excel error "#NAME?". And I can't find a way to avoid that errormsg. (sigh: some days it jes' ain't worth gettin' up)

Excel sees it as a number - i don't know an easy way to avoid it - other than to use ' as a prefix to force Excel to read a cell as text.

I don't think it will work to set the cell format as text because excel has already added the = to the formula. Try search and replace for =, replace it with nothing.

 
F

FSOphof

I don't think it will work to set the cell format as text because excel has already added the = to the formula. Try search and replace for =, replace it with nothing.

Subscribe to Exchange Messaging Outlook weekly newsletter

Replacing "=" with a nullstring worked very nicely. Thanks!

Scott
 
Status
Not open for further replies.
Top