sqlcurious
asked on
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
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
ASKER
sorry its not working...I used the same formula but the link says cannot open page
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?
something like
=HYPERLINK("http://" & A2,B2)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
Q-27838291.xls