This question already has an answer here:

My requirement is I have one cell with text and the next cell with a hyperlink. I need to add only the hyperlink to the text. Any ideas on how this can be achieved? I want to automate or use a formula so that it can be applied to all the 200 rows I have.

marked as duplicate by Dave, fixer1234, DavidPostill, mdpc, Ben N Jul 29 '16 at 22:12

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


This can be done with the formula




where B1 is the hyperlink cell and A1 is the name

Not the answer you're looking for? Browse other questions tagged or ask your own question.