Formula similar to MID function

[Beth]

I just did this today! Glad to pass on what we did...

Here's the formula: =RIGHT(A18,LEN(A18)-FIND(",",A18)-1)

And here's the explanation:
First you need to know where the comma is, so:
FIND(",",A18) results in 8

Next, you need to know how long the whole name is, so:
LEN(A18) results in 14

Then you subtract one from the other to get the position
of everything after the comma, and subtract 1 more for the
comma:
=LEN(A18)-FIND(",",A18)-1

Finally, you only want the text to the right of the comma,
so you use a RIGHT formula like this:
=RIGHT(A18,LEN(A18)-FIND(",",A18)-1)