to create link for every URL in excel

Hi experts,
I have prolly 500 rows of differnt URL's which are in txt form and I am trying to make a hyperlink but I can only do individually, but it would be too much work to do individually.
Can hyou please suggest a way I can do a hyperlink for all at once.
Below is the example of the kind of links I have(dummy links):
URL                                             Description
www.mca.com/621*30401        item1
www.mca.com/621*30402        item2
www.mca.com/621*30440        item3
www.mca.com/621*30509        item4
sqlcuriousAsked:
Who is Participating?
 
Robert SchuttSoftware EngineerCommented:
added some checking, here is a new file.
Q-27838291.xls
0
 
Robert SchuttSoftware EngineerCommented:
How about this, copy down as much as needed.
Q-27838291.xls
0
 
sqlcuriousAuthor Commented:
sorry its not working...I used the same formula but the link says cannot open page
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Robert SchuttSoftware EngineerCommented:
ah sorry, the prefix "http://" is missing. I'll post a new version if you want, but maybe you can add that in the formula?
0
 
Robert SchuttSoftware EngineerCommented:
something like
=HYPERLINK("http://" & A2,B2)

Open in new window

0
 
sqlcuriousAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.