From the link I posted earlier:

"ISO-8859-1 explicitly does not define displayable characters for positions 0-31 and 127-159, and the HTML standard does not allow those to be used for displayable characters."

Epinn

"Epinn" wrote in message ...
Now all I need to do is figure out why. <<

CHAR(160) and CHAR(34) are nonprintable characters which I alerted you to.

http://www.htmlhelp.com/reference/charset/

CHAR(160) - non-breaking space
CHAR (34) - double quotes

Gary's student may be able to explain better. I thought of CHAR(160) but not CHAR(34). Good job.

Epinn

"Frank B Denman" wrote in message ...
Wow! That works! Now all I need to do is figure out why.

Thanks so much for this gift.

Cheers,

frank


On Mon, 5 Feb 2007 06:22:01 -0800, Gary''s Student
wrote:

=HYPERLINK(TRIM(SUBSTITUTE(SUBSTITUTE(E2,CHAR(34) ,""),CHAR(160),"")))
Frank Denman
Denman Systems

[Please delete the "x" from my email address]