Concatenate using a linked field?

[Jotink78]

Good afternoon. I've got a large spreadsheets, and I am trying to get concatenate to work on two columns, one of which is a link to a document on an internal server. When I do this, the link breaks and only the text is showing.

Ex: A1 = ABC Company, B1 = Link. For C1, I want it to show ABC Company, Link, so that "Link" is still a hyperlink and is clickable.

When I use the formula (=CONCATENATE(A1,", ",B1), it combines the text from both fields fine, but the actual hyperlink is no longer there. I know I could go in and re-add the hyperlink manually, but I was hoping to avoid having to go into 1,000 cells and add a hyperlink. Not sure if there is a way to do this with concatenate, or if it's another formula entirely that I'm needing. Any ideas would be appreciated!

 

[alexw123]

Hi,

Try this =HYPERLINK(B1,CONCATENATE(A1,", ",B1)).

This will make "ABC Company, link" into a link. Not sure if its possible to only have part of a text string become a link without using doing it by hand, but lets see if any experts have any cool formulas they could use!

Hope this helps,

thanks

 

[Jotink78]

I wasn't able to get that to work, but since it's probably not possible to link only a portion of the text in the same cell, I was able to come up with a work around that didn't involve using the "concatenate" formula. But thank you so much for your help!