CODEWITHSUNDEEP
excel
Divya Roopam
Divya Roopam

Reputation: 59

Combining text and hyperlink in excel

I have text in column B and hyperlink in Column C. I need to concatenate these in column D. But the hyperlink disappears on concatenation in Column D. Cannot find anything online. Can someone please help?

B                               C   
Quaterly Results are here:      https://bloomberg.com   

D
Quaterly Results are here : https://bloomberg.com

I have used the following formulas , none works:

=B2 & "" & HYPERLINK(C2)
=CONCATENATE(B2,"", HYPERLINK(C2))

Upvotes: 0

Views: 3276

Answers (1)

Praveen DA
Praveen DA

Reputation: 354

try this formal

=HYPERLINK(C2,CONCATENATE(B2,C2))

C1 should be the link

B1 should be name for the hyperlink

enter image description here

Upvotes: 1

Related Questions