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




Ron Rosenfeld wrote:
On 21 Jan 2007 10:07:34 -0800, "okrob" wrote:

Can someone take a look at this post:
http://groups.google.com/group/micro...953084d4a98d93

The group isn't very active today and I need help as soon as
possible...
Thanks,
Rob


Download and install Longre's free morefunc.xll add-in (easily distributed with
the workbook if that is an issue) from http://xcell05.free.fr

Then use this formula:

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

--ron