View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank B Denman Frank B Denman is offline
external usenet poster
 
Posts: 5
Default Can't make hyperlink function work for hyperlink to website

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]