Text Formatted Columns show as XXXXXXX

  • Thread starter Thread starter Kerry K
  • Start date Start date
K

Kerry K

HI,I am trying to save a file as .csv for uploading to
another system. One requirement is to format all columns
as text. One of the columns is called NOTES and contains
only text, no funny characters, etc. Some of the cells in
this column change to XXXXXXX when I format them to Text
from General. If I shorten the length of the text in the
cells everything is fine. I checked the Data Validation
on these cells and there is no limits or anything on
them. Is there some Maximum Default for cell length for
TEXT formatted cells. Any help would be greatly
appreciated.
 
-----Original Message-----
HI,I am trying to save a file as .csv for uploading to
another system. One requirement is to format all columns
as text. One of the columns is called NOTES and contains
only text, no funny characters, etc. Some of the cells in
this column change to XXXXXXX when I format them to Text
from General. If I shorten the length of the text in the
cells everything is fine. I checked the Data Validation
on these cells and there is no limits or anything on
them. Is there some Maximum Default for cell length for
TEXT formatted cells. Any help would be greatly
appreciated.
.
Click to expand...

Just as an addition fact, the cells in question usually
have 300 to 500 characters in them. Thanks.
 
There seems to be a problem with text length between 256-1024 (0-255 and 1025+
work ok).

The bad news is that this is the way excel works.

I'm not quite sure why you have to format the column as Text--since the .csv
file doesn't care about that.

But if you want more control over how the .csv file gets created, you could
create your own macro.

here are some samples:

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html
 
Back
Top