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]