Frank, now I can congratulate you! I am glad that you were detailed and mentioned "import" and it really caught my eyes. I had a feeling that it might have something to do with nonprinting characters but still surprised why the balloon showed. Anyway, I am happy for you.

I wonder if CLEAN works at all. Gary's student, would you please help me learn.

Thanks.

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]