Actually, I don't have a comma. It's just LastName FirstName MiddleInitial
all separated by spaces


Patty wrote:
I have over a thousand cells with last name,first name. I want two different
cells with last name in one and first name in the other (minus the comma).
Any ideas? (no VB please!)

Thanks.


--
Message posted via http://www.officekb.com