Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel General » Text not recognised as text...

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-21-2009, 06:08 AM
lumish lumish is offline
Registered User
  
Join Date: 21 Jul 2009
Location: Cambridge, UK
MS Office Version:Excel 2003
Posts: 2
lumish is becoming part of the community
Post Text not recognised as text...

Please Register to Remove these Ads

Hi everyone,
I have this issue with text which I copied from a secure internet site. The text looks as though it pasted into my excel spreedsheet properly; I could manipulate it like normal text. However, when double clicking the row height to reduce/increase to the right height, the height could change but it sometimes left a space where there was no text.

I then went to check the format of the text and it was presented as 'General' but in the sample box '#############' was shown instead of the text. I then tried to change the format to 'Text' but when I pressed enter it then changed the cell to show '###########' instead of the text that was there before.

Can anyone out there help me with what I can do to convert whatever the format of text I have at the moment into an Excel recognised text?

Thanks,
lumish
Reply With Quote
  #2  
Old 07-21-2009, 08:10 AM
martindwilson's Avatar
martindwilson martindwilson is offline
Forum Guru
  
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,073
martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding martindwilson Has a higher level of understanding
Re: Text not recognised as text...
need to see a sample
__________________
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code

how to enter array formula

recommended reading
wiki Mojito

how to say no convincingly

most important think you need
Reply With Quote
  #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,157
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
  #4  
Old 07-22-2009, 10:11 AM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,491
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: Text not recognised as text...
Quote:
and the text is between 255 and 1024 characters long, the cell will display ######
256 and 1024, I think, Stomper. And in Excel 2007, its 256+.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #5  
Old 07-22-2009, 10:20 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,157
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...
I have a unique interpretation of the word 'between'. (you are of course quite correct)
I'm still trying to ignore the existence of 2007...
__________________
HTH,
R.

I am never wrong, but occasionally reality fails to live up to my expectations.
Reply With Quote
  #6  
Old 07-22-2009, 10:59 AM
lumish lumish is offline
Registered User
  
Join Date: 21 Jul 2009
Location: Cambridge, UK
MS Office Version:Excel 2003
Posts: 2
lumish is becoming part of the community
Re: Text not recognised as text...
Ahh... I see... I played around with the text a bit and you're both perfectly right!! Thanks!
Reply With Quote
  #7  
Old 07-22-2009, 11:23 AM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,491
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: Text not recognised as text...
Quote:
I'm still trying to ignore the existence of 2007...


martindwilson only just recently moved from Excel 97; we had great fun ragging him about the teletype he probably used to receive email and his 4" floppies.

In 2015, I'll be Martin, still using Excel 2003 unless physically beaten.
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote
  #8  
Old 07-22-2009, 11:29 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,157
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...
Quote:
Originally Posted by shg View Post
...and his 4" floppies.
struggling not to respond...
Quote:
In 2015, I'll be Martin, still using Excel 2003 unless physically beaten.
Don't speak too soon - all I can say is that things are improving...
__________________
HTH,
R.

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


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top