text manipulation

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" <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
> >

--

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" <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
> > >
>
> --
>
> Dave Peterson

--

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" <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
> > >
>
> --
>
> Dave Peterson

--

Dave Peterson