Splitting text strings down to specific identifiers
Hello /excel,
I have a sheet containing a thousand(ish) text-only URLs and am attempting to create hyperlinks for each using the webpage as the text for the link.
For example if I have http://www.website.com/page I wish for the hyperlink text to simply state 'page'.
I have successfully achieved this with the following:
=HYPERLINK('A2; SUBSTITUTE('A2;"https://www.website.com";""))
My issue is that the initial string isn't always the same and could be anything from the following:
https://www.website.com/page
https://uk.website.com/page
https://es.website.com/page
https://za.website.com/page
etc.
Basically, the 'www' could change, but the rest is the same - i.e. everything is from the same website.
Is there a way to include these different iterations of the web address in my current function or another elegant way to solve this?
[link] [comments]
Want to read more?
Check out the full article on the original site