ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   truncation of fields inported from access (https://www.excelbanter.com/excel-worksheet-functions/199267-truncation-fields-inported-access.html)

liddleti

truncation of fields inported from access
 
How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text.

Spiky

truncation of fields inported from access
 
On Aug 18, 4:18 pm, liddleti
wrote:
How do I work around the 255 character truncation of text fields in excel. I
am exporting from access to excel and loosing text.


Try formatting the cells as General. Versions as old as Excel 2000 can
have far more characters than this in a cell, but you may need to
change out of Text format, I forget exactly how this works.

Excel 2007 is unlimited or something like that, if upgrading is an
option.


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com