You are very welcome. I just followed Epinn's advise and made a formula out
of it.

Epinn deserves the credit for this one.
--
Gary's Student
gsnu200704


"Frank B Denman" wrote:

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]