Create Hyperlinks

[cgendron]

Hello all,

I have a list of website bookmarks, not hyperlinked, just text. They are all listed in column A. I know i can select each one and choose "hyperlink" and copy the link and paste it to manually create a hyperlink but is there a formula to automatically create the hyperlink? I have a few hundred and don't want to do each one individually.
Thanks!

 

[JazzSP8]

Sounds like a job for;

=HYPERLINK(CELL REFERENCE)

 

[cgendron]

Wow, ok that seemed so simple Thanks, worked perfectly!

 

[JazzSP8]

Aye, it's simple when you know how - Like everything else

You're welcome