How do I remove Char(160) from a cell?
 

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.

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

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.