The exact problem i'm having is with separating the middle name or middle initial. I can separate a field with a 1st name and last name but i can make this work whenever it includes a middle name. Can u include an example of how to solve this problem?

----- Rone wrote: -----

You could use the "Left","Right", or "Mid" functions to do
this.


-----Original Message-----
What command would allow me to do the opposite of
CONCATENATE in Excel? I'm trying to break-up a field with
a full name, hence i need to extract the first name,
middle and last name.
.