Say I have two columns, one with string literal names, and one with links (in text form)
A B Restaurant 1 http://www.link1.com Restaurant 2 http://www.link2.com
I want to combine these, which I can easily do via
HYPERLINK within another column, say C:
A B C Restaurant 1 http://www.link1.com Combined Link+Name 1 Restaurant 2 http://www.link2.com Combined Link+Name 2
My issue though, is I want to replace column A with my new combined hyperlink + name field - my ultimate goal is to combine my name and link columns into one and no longer need either.
A B Combined Link+Name 1 http://www.link1.com Combined Link+Name 2 http://www.link2.com
If I paste the combined column, or delete the existing columns, it results in removing at least one of the references in the link, resulting in either a
REF error or the loss of the either the text or the link. In most cases like this, I could just paste values, but pasting values loses the link, which I need to keep. Is anyone aware of a way around this?