the easiest way is to use the Mid, Left and Right
functions.
The instr function can help you find where comma and/or
space separators between the names are.

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