text manipulation

[eenstudent]

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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>

[eenstudent]

Very helpful -- thank you!!!

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



Bernie Deitrick wrote:
>
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

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



Bernie Deitrick wrote:
>
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

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



Bernie Deitrick wrote:
>
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

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



Bernie Deitrick wrote:
>
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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

[Bernie Deitrick]

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

HTH,
Bernie
MS Excel MVP


"eenstudent" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[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" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> =HYPERLINK("www." & A1 & ".com","Click to connect to Blooper")
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "eenstudent" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >
> > > 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