Example:
I have a worksheet in Excel 2010 Pro Plus that contains a list of "groups" and "pages" that I am a member of on a social media site.
When I copied those names from the site, the paste function added the hyperlinks to the actual webpage associated with the group or page.
Now I want to extract the URLs from the list of 20,000 items and insert those URLs into a different column.
Instead of doing this manually (and going crazy), I would like to automate this process.
I am not a programmer. While I can make Excel do lots of things, I am not a programmer. Nor do I pretend to be one.
So, please post step by step as you would for a noob, using easy to understand language as you would for your grandmother.
Thanks!
DM
Bookmarks