1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/Swalf88
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article