0

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.

0

This can be done with the formula

=HYPERLINK(link_location;friendly_name)

Example:

=HYPERLINK(B1;A1)

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.