Hello,
I have a very large column of individual website addresses. I would like to insert "www." in front of each and create a hyperlink for each also.
What is the easiest way to do this?
Thx
Hello,
I have a very large column of individual website addresses. I would like to insert "www." in front of each and create a hyperlink for each also.
What is the easiest way to do this?
Thx
Perhaps then
B1: =HYPERLINK("http:\\www."&A1,A1)
copied down
(where A1 contains www-less address)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks