=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.