Epinn deserves the credit for this one.

That is very kind of you. I was in the right direction but without your formula I might not be able to substantiate my suspicion. Collaboration works wonders. This is what the forum is about.

Previously I wrote: I wonder if CLEAN works at all.

I figure it out. CLEAN is tricky and does only half of a job.

The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). By itself, the CLEAN function does not remove these additional nonprinting characters. <<

I am glad I invested time in this thread as I have learned a few things.

Epinn

"Gary''s Student" wrote in message ...
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]