Trying to trim the base of a URL, getting stuck

I have a column on a board with Twitter URLs. I’d like to trim out “https://twitter.com/” and be left with just the user name after the last /.

Example:
Begin: https://twitter.com/mytwitter
End: mytwitter

Does anyone have a formula that does this? I can’t find a function that easily searches the string, removes it, leaves the rest.

My goal is to VLOOKUP app this information against a column in another board.

Any help would be a life saver- Thanks!

Hi Bruce
If it’s just the https://twitter/
you always want to remove you can use the substitute formula below
you will just need to replace address for the name of your column
SUBSTITUTE({Address},“https://twitter.com/“,””)
Screenshot 2022-10-14 at 11.48.32

If you need any additional assistance
Please don’t hesitate to give me a shout
Many thanks
Dan