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.
.