convert text to hyperlink
 

i was given a list of sites to incorporate into a spreadsheet. the sites were
plain text, not set up as hyperlinks. the list is rather lengthy. is there
an easy way to convert the text into working hyperlinks? I want to jump to
the sites once you click on the link.

example:

napw.com
retirementjobs.com
clutchmagonline.com
koreadirect.com
africanmag.com
latiplanet.com

convert text to hyperlink
 

I'd use an adjacent column:

=hyperlink("http://" & a1, a1)
and drag down.

(maybe hide that original column, too???)

se7098 wrote:

i was given a list of sites to incorporate into a spreadsheet. the sites were
plain text, not set up as hyperlinks. the list is rather lengthy. is there
an easy way to convert the text into working hyperlinks? I want to jump to
the sites once you click on the link.

example:

napw.com
retirementjobs.com
clutchmagonline.com
koreadirect.com
africanmag.com
latiplanet.com

--

Dave Peterson

convert text to hyperlink
 

Thanks Dave - perfecto!!!

"Dave Peterson" wrote:

I'd use an adjacent column:

=hyperlink("http://" & a1, a1)
and drag down.

(maybe hide that original column, too???)

se7098 wrote:

i was given a list of sites to incorporate into a spreadsheet. the sites were
plain text, not set up as hyperlinks. the list is rather lengthy. is there
an easy way to convert the text into working hyperlinks? I want to jump to
the sites once you click on the link.

example:

napw.com
retirementjobs.com
clutchmagonline.com
koreadirect.com
africanmag.com
latiplanet.com

--

Dave Peterson