On Fri, 6 Jan 2006 12:06:03 -0600, jermsalerms
wrote:


Ron,

I found that when a persons name starts with M it skips the first name
and inputs the middle initial

for example

MICHEAL B SMITH

returns

B

How would this be corrected?

Ignore my last. Use this instead:

=REGEX.MID(A1,"(?!(D|M)(\w{0,2}(\.\s|\s)))(?<=\s|^ )\w+(?=\s)")


--ron