First time here? Check out the FAQ!

1 | initial version |

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 )
```

2 | No.2 Revision |

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 )
```

3 | No.3 Revision |

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 )
```

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.