Hi,
Col 1 Col 2
hyperlink blank
a number hyperlink
text hyperlink
What I want to do is to cut and paste the hyperlink from column 1 into Col 2. But I've got 11,000 records so I need to automate the process.
So what I'm trying to say is 'if Col 1 contains a hyperlink, please cut that hyperlink and put it into Col 2 but if Col 1 contains anything other than a hyperlink, don't do anything.
So I end up with:
blank hyperlink
a number hyperlink
text hyperlink
And the resultant hyperlink must work (in some of my experiments the url doesn't appear).
I've basically copied and pasted a lot of records from a website and I'm now trying to get everything in the right columns.
Any help appreciated.
Thanks
feynsteclay
Bookmarks