convert text to hyperlink

[se7098]

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]

I'd use an adjacent column:

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

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

 

[se7098]

Thanks Dave - perfecto!!!

I'd use an adjacent column:

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

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