Not infrequently, I need to strip out all of the text up to and including a certain character. For example, in a list of legal cases in the form "Plaintiff v. defendant", I might want to strip off everything up to and including "v. " to get a list of defendants.

This is easily accomplished using a combination of the `FIND`, `RIGHT`, and `LEN` functions as follows (using `A1` as the cell where text is coming from):

```
=RIGHT(A1,LEN(A1)-FIND("text",A1)-1)

```

But has always struck me as somewhat clunky and error-prone (not to mention that I usually forget to subtract 1. Is there a more elegant way of achieving the same result?