If you've got a strange character at the beginning or end of your string,
=CODE(LEFT(A2)) or =CODE(RIGHT(A2)) should show it. If it were a normal
space the result would be 32 (hex 20). If it's a non-breaking space the
result will be 160.
Once you know what you've got you can cure it with something like
=SUBSTITUTE(A2,CHAR(160),"").
--
David Biddulph
"mkcma via OfficeKB.com" <u48424@uwe wrote in message
news:8f59d5cd3d13f@uwe...
0221737
this is an example on one sheet that is 7 visible numbers (format is back
to
'general; at this point).
I did =Clean and have tried =Trim. The =LEN(-) Still counts 8. Do I have
to
re-type each and every part number?
mk
(tks for everyone's patience)
xlmate wrote:
Use the Trim or CLEAN function to clear unwanted characters,
eg.
=TRIM(your data) or =CLEAN(your data)
Look at Help, there's some examples
HTH
Pls click the Yes button if this help.
cheers, francis
I did a length count and one set has 8, the others have 7 - and 10 vs 9
etc.
[quoted text clipped - 10 lines]
--ron
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1