Ask Your Question

Revision history [back]

A less elegant way using a formula

=RIGHT(A1, LEN(A1) - (SEARCH("\",A1,SEARCH("\",A1,SEARCH("\",A1)+1)+1)) )

To find the location of the third backslash

 - It searches for the location of the first backslash
 - Then it starts another search from that location to find the second backslash
 - Then another from that location to find the location of the third backslash

Using the RIGHT function

 - RIGHT( Text , Number of chars at the end of the string )

A less elegant way using a formula

=RIGHT(A1, LEN(A1) - (SEARCH("\",A1,SEARCH("\",A1,SEARCH("\",A1)+1)+1)) )

To find the location of the third backslash

 - It searches for the location of the first backslash
 - Then it starts another search from that location to find the second backslash
 - Then another from that location to find the location of the third backslash

Using the RIGHT function

 - RIGHT( Text , Number of chars at the end of the string to keep )

A less elegant way using a formula

=RIGHT(A1, LEN(A1) - (SEARCH("\",A1,SEARCH("\",A1,SEARCH("\",A1)+1)+1)) )

To find the location of the third backslash

 - It Basically it searches for the location of the first backslash
 - Then it starts another search from that location to find the second backslash
 - Then another from that location to find the location of the third backslash

Using the RIGHT function

 - RIGHT( Text , Number of chars at the end of the string to keep )