=HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")

HTH,
Bernie
MS Excel MVP


"eenstudent" <eenstudent.1s45nb_1121267224.3874@excelforum-nospam.com> wrote in message
news:eenstudent.1s45nb_1121267224.3874@excelforum-nospam.com...
>
> If I have in a given cell a one-word name (e. g. "blooper"), and want to
> convert that name to a url format (e. g. "www.blooper.com"), what
> formula/function must I use?
>
> Thanks in advance,
>
> eenstudent
>
>
> --
> eenstudent
> ------------------------------------------------------------------------
> eenstudent's Profile: http://www.excelforum.com/member.php...o&userid=25192
> View this thread: http://www.excelforum.com/showthread...hreadid=386808
>