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

[Dave]

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.

[Bob Phillips]

=SUBSTITUTE(E1,CHAR(160),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>

[Dave]

Thanks that did the trick!!


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> =SUBSTITUTE(E1,CHAR(160),"")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Dave" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>>
>>
>
>