to create link for every URL in excel

Posted on 2012-08-22
Medium Priority
Last Modified: 2012-09-07
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
Question by:sqlcurious
  • 4
  • 2
LVL 35

Expert Comment

by:Robert Schutt
ID: 38321723
How about this, copy down as much as needed.

Author Comment

ID: 38321940
sorry its not working...I used the same formula but the link says cannot open page
LVL 35

Expert Comment

by:Robert Schutt
ID: 38321980
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?
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 35

Expert Comment

by:Robert Schutt
ID: 38321987
something like
=HYPERLINK("http://" & A2,B2)

Open in new window

LVL 35

Accepted Solution

Robert Schutt earned 2000 total points
ID: 38324077
added some checking, here is a new file.

Author Closing Comment

ID: 38377280

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question