Thread: Text not recognised as text...
View Single Post
  #3  
Old 07-22-2009, 09:09 AM
romperstomper's Avatar
romperstomper romperstomper is offline
Valued Forum Contributor
  
Join Date: 04 Nov 2008
Location: The inner wardrobes of my mind
MS Office Version:95 onward (except 97)
Posts: 2,167
romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding romperstomper Has a higher level of understanding
Re: Text not recognised as text...
Text does not need to be explicitly formatted as Text and in fact, if you do format the cell as Text and the text is between 255 and 1024 characters long, the cell will display ###### as you found (longer or shorter will display OK).
If you copy and paste from the internet you will get all sorts of interesting characters in the text like chr(160) (a non-breaking space).
__________________
HTH,
R.

I am never wrong, but occasionally reality fails to live up to my expectations.
Reply With Quote