On Mon, 30 Jan 2006 10:57:28 -0800, NewKid <[email protected]>
wrote:

>Hello Ron,
>Thank you for your help. The "morefunc.xll" functions are very useful. I
>appreciate this. Thanks again.
>Mary

Mary,

Thinking about possibilities, the expression I gave you (for the third column)
has a problem if anything in the first two words contains a dot (e.g. Millisa
N. Azille). So this will correct that oversight:

=REGEX.SUBSTITUTE(TRIM($A1),"^(\w+\.?(\s|$)){1,2}")


--ron