How Do? Take two words in cell 1 and slpit them to cell 2 & 3
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?
This should do it, and will also remove the space following the FN.
=REGEX.MID(A1,"(?!D|M(\w{0,2}(\.\s|\s)))(?<=\s|^)\ w+(?=\s)")
Did you also see my note about the Last Name issue?
--ron
|