Thanks that did the trick!!
"Bob Phillips" wrote in message
...
=SUBSTITUTE(E1,CHAR(160),"")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dave" wrote in message
...
I pasted data into a spreadsheet form an html table. I found there in a
Char(160) character on eoither side of the data. I want to strip this
character. This character is an nbsp in HTML.
|