Home

Combining Two Columns Into One Hyperlinked Column

trgsp
Occasional Contributor

Hello:

Is it possible to combine two columns into one hyperlinked column? I have one column with company names; the other with the company's website address. How can I combine them into one column with the company name hyperlinked?

 

Thank you.

3 Replies

That could be like

=HYPERLINK(IF(LEFT(B1,4)="http",B1,"http://" & B1),A1)

Thank you, Sergei, for the response. It worked and it didn't work, and I'm sure it's on me because I'm not very good with Excel. I am familiar with code (HTML, JAVA, etc.) just not working with code in Excel, so a couple of questions.

  • I understand the first part of the code, but what does the "4" right after it represent? Am I supposed to change that to something else? 
    =HYPERLINK(IF(LEFT(B1,
  • When I tried the code I had put it in after both the company name and company website columns. When I hit enter it created a hyperlink of the website address, not the company name, which is what I am hoping to achieve. I am wondering if it's because I entered the code after the two columns and maybe should have put the code between the two columns? I'm not sure, or even it matters.

Any suggestions?

 

Thanks, Michael

 

Hi Michael,

 

Let me explain on the sample like this

image.png

HYPERLINK has two parameters, first one is the text with the link and second one is the name of it. However, it forwards on web site if only the link starts from "http://", otherwise it doesn't work.

 

Thus first we check if our link has http in the front (usually not). To check we use LEFT on cell on B which takes first 4 symbols (second parameter here) from the text in the column B cell. If not, we add that text to the string "http://", otherwise take it as it is (IF function).

 

Please check in attached.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies