Substring Find last occurence of and output everything to the right of it

Question

I want to use a formula that will output everything to the right of the final instance of the forward slash character (/) after it is located. Here's an illustration:

/shared/Custom/Conversion_Reports/Supplier Address/Supplier Address Rejection.xdo

To print everything to the right of the last slash in this example, which is the fifth one above (counting from left to right), I would type Supplier Address Rejection.xdo.

I need to use some sort of locate function because the folder names all have varied lengths and there are different numbers of folders (slashes), but I'm not sure how to discover the final instance of a particular character. I appreciate it.

Answer 1

Use TEXTAFTER() Function:

=TEXTAFTER(B2,"/",-1)