Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to export those hashed (##) text cells

Best of Excel

How to export those hashed (##) text cells

by  bigfoot  Posted    (Edited  )
If you ever need to deal with spreadsheet cells that are formatted as text and are full of long text values (exceeding 255 characters) you'll undoubtedly see those this hash marks or sometimes called number signs.
Excel uses these to tell you that it can not display a text cell larger then 255 characters.

If you try and export your spreadsheet to a comma or tab delimited format, the number signs (####) will be there too.

So what do you do? You convert the column to the General format. Yes it is that easy.
Excel will gladly show you all of the text and export it nicely.

Hope this helps someone.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top