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))
I was searching for this tutorial , thanks a lot for sharing it here Jed. May I know if you have a subscribe button so that I will be notified every new blog post.