Try:
Right(strAttorneyName, Len(strAttorneyName)- InStrRev(strAttorneyName, " "))
or:
Split(strAttorneyName, " ")(Ubound(Split(strAttorneyName, " "))

Do note, however, no such approach will return names that have two or more words (e.g. St James, Van Heusen). For that, you really need to have separate textboxes for the Attorney given & family names.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]