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

Tagged with

#rows.com
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#hyperlinks
#URLs
#HYPERLINK
#SUBSTITUTE
#webpage
#text strings
#link
#domain variations
#http
#web address
#website
#regional domains
#identifier
Splitting text strings down to specific identifiers