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

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

HTH,
Bernie
MS Excel MVP


"eenstudent" wrote in message
...

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

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

HTH,
Bernie
MS Excel MVP


"eenstudent" wrote in message
...

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

Very helpful -- thank you!!!


--
eenstudent
------------------------------------------------------------------------
eenstudent's Profile: http://www.excelforum.com/member.php...o&userid=25192
View this thread: http://www.excelforum.com/showthread...hreadid=386808

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.)



Bernie Deitrick wrote:

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

HTH,
Bernie
MS Excel MVP

"eenstudent" wrote in message
...

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


--

Dave Peterson

I didn't see your later enhancement (about the &A1 stuff).

Sorry,

Dave Peterson wrote:

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.)

Bernie Deitrick wrote:

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

HTH,
Bernie
MS Excel MVP

"eenstudent" wrote in message
...

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


--

Dave Peterson

--

Dave Peterson