In excel 2008 I have a list of 200+ websites that are hyperlinked to their respective web addresses in column A. I need to list all of the actual web addresses in column B. I really don't want to have to edit each hyperlink, copy the web address, and then paste it into column B. Is there a function or something that I can use to do the work for me? I was going to create a UDF but I guess 2008 doesn't support that. Please help.
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Unmask a hyperlink to show the web address
- Thread starter textLingo
- Start date
- Sort by reaction score