LyndieBee wrote:
I know how to concatinate a first name field with a last name field, but how
do I take a list of names (i.e. JAMES SMITH) and break them apart into a
first name field and a last name field? Thanks for any suggestions.

Check out Data|Text to Columns

Alan Beban