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.