Automatically create a URL/HREF in an Excel field

You output 5000 rows of data into Excel for a client to review and need to make them all HREFs.

The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article.

We have this:

ArticleID URL
456

And we want to get to this:

ArticleID URL
456 http://www.processio.com/articletrigger.php?articleid=465 (this URL  does not work)

 

It’s easy!  You just need two functions:

  • HYPERLINK()
  • CONCATENATE()

Create a new column and add the following. Replace the URL with the URL you need, and point the cell load position to the respective cell. Drag down and you’re done.

=HYPERLINK(CONCATENATE(“http://www.processio.com/articletrigger.php?articleid=”|A2))

One Comment

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.