To be consistent, I guess that should have been

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

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:uHow407hFHA.2852@TK2MSFTNGP15.phx.gbl...
> =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
>>
>
>