I have an Excel2007 file contains a long list of company names (some thousands); each name is a hyper link that leads to the website of this company.
Is there a formula (not VBA code) that can convert the list into another list consists of the website of each company?
Regards

---

Richard Responds:

So let me get this straight... you've got a column of hyperlinks that are formatted as clickable hyperlinks, and you just want to break it down and get the URL address WITHOUT it being a clickable hyperlink?

A quick test in Excel shows me that if you have the hyperlink in A1, and you put the following in B1, you get exactly what you're looking for:

=A1

Yep. That's it. Apparently Excel gets the URL address from A1 and doesn't make it an actual hyperlink. Hope this is what you're looking for.