Hello again,

I was using your formula and it was working great. However, I got an erroneous result when I encountered a name like:
Smith Jr., Billy A "Ben"

The formula returns the value "Jr.".

I tried messing with the formula to get it to work but no avail.

Your help would be greatly appreciated.