I did finally figure that out too after playing with the function.
Thanks again,
Rob


Ron Rosenfeld wrote:
On Sun, 21 Jan 2007 14:54:48 -0500, Ron Rosenfeld
wrote:

On 21 Jan 2007 11:34:10 -0800, "okrob" wrote:

Thanks Ron...
This worked great! Looks like I added a whole host of functions with
this addin...
Best part about it is that it's distributable.
Rob

You're welcome. Thanks for the feedback.

Yes there are a number of useful functions. And they can also be used from
within VBA.

About the only downside I've found is that inputs are limited to 255
characters.
--ron

I noted in a previous posting that you wanted to get rid of the initial space
if there was not middle initial.

You could modify the function I posted as follows:

=REGEX.SUBSTITUTE(A1,"\s*(\w+)\s+(\w+).*",
"=if(len(""[1]"")=2,"" [2], [1]"",""[2], [1]"")" )


--ron