Split First/Last Name

[Shannon]

How can I split an old field that was first and last name
to be in two fields: FirstName and LastName? They are
only separated by a space.

 

[Cheryl Fischer]

In VB Help, check out the Left(), Mid() and InStr() functions.