I would've thought this would be incredibly simple but, well, it's not so far.
I have a list of over 500 urls in one column that are not real links. I'd like to convert them to proper functioning links. I can do this using the 'hyperlink' code in an adjacent column, but it relies on the source column to remain.
I need another piece of code to convert the real links column into a self sufficient list of urls. I've tried pasting special but although it removes the code the url goes too.
Any pointers people?
Cheers.
I have a list of over 500 urls in one column that are not real links. I'd like to convert them to proper functioning links. I can do this using the 'hyperlink' code in an adjacent column, but it relies on the source column to remain.
I need another piece of code to convert the real links column into a self sufficient list of urls. I've tried pasting special but although it removes the code the url goes too.
Any pointers people?
Cheers.