text manipulation

E

eenstudent

If I have in a given cell a one-word name (e. g. "blooper"), and want t
convert that name to a url format (e. g. "www.blooper.com"), wha
formula/function must I use?

Thanks in advance,

eenstuden
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

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 said:
=HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")

HTH,
Bernie
MS Excel MVP
Click to expand...
 
D

Dave Peterson

I think you'll need http:// to get the link to work:

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

(slight change to the string to show, too.)
 
Top