There is no way for a Find/Replace to 'know' what is a first name or a last name. That said, it appears from your data that the entries starting with the last name also have commas, whereas the others do not. In that case, you could use a wildcard Find/Replace, where:
Find = (^034)([!,^034]@), ([!^034]@)\1
Replace = \1\3 \2\1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|