The links appear hyperlinked with blue line in Excel, I want to extract the text from the link e.g. The url http:\sea.craigslist.com appears as "seattle" in excel. I want to extract the text "sea" out of the link and paste in a next column.
This formula will pull out all text after the
However, this relies on the hyperlink URL being the visible text, and doesn't work when they are showing thier friendly name. In otherwords it doesn't work when the hyperlink is showing as just "Seattle", because the formula works on that instead of the URL.
So far, I cannot find a way around this issue without resorting to a custom VBA function - in which case the entire thing may as well be a custom function. Would this be an acceptable solution?
Alternatively, does anyone know of a built-in function to extract the link's target?