Convert Text URL Column Into Hyperlinks In Excel

In this post we will see how could we convert a number of text url’s in a column to hyperlink at once.

It could prove to be a hectic task if you have a list of text url’s in a column in excel, and you need t9o convert them into hyperlinks.

There could be two approach two convert a list of text url’s into hyperlink, first approach would be to do so one by one (which would be quite exhaustive, needless to say)  and the other one would be to convert all of them into hyperlinks all at once with the help of formula in excel.

Below is the sample data which shows a list of text url’s in column A, and we want to have them converted into hyperlinks.

table showin text url's

We will use a simple HYPERLINK() formula in excel to convert a large number of text URL’s into hyperlink.

Enter formula =HYPERLINK(A2) in cell B2 to convert text url in cell A1 into hyperlink.

excel formula converting text url's into hyperlinks

Now drag the formula till row number 5 to convert all the text url’s into hyperlink in excel.table showing text url converted into hyperlinks

As you could see, all the text url’s in column A have been converted into hyperlinks.

Hope this helped.


Share The Knowledge

Random Posts

  • Change Name Range In Excel

    Name range is of the most useful features in excel.The challenge in our day to day excel activities are that […]

    Share The Knowledge
  • Excel Formula To Sum Values Between Two Dates

    find sum of values between two dates in excel, excel formula to get the sum of a column between two dates, sum formula between two dates,sum of all the values between two dates in excel

    Share The Knowledge
  • Return Formula As String In Excel

    Let’s see how to return a formula as string or formula as text in excel. We often come across a […]

    Share The Knowledge
  • Set Column Width In Excel

    The post demonstrates how to set column width manually in excel. Suppose you have some numeric value to set column […]

    Share The Knowledge

Leave a Reply