How to separate names into 2-separate fields

[djclntn]

Have a field with both first & last names, “Tom Jones” I want first & last names in 2-separate fields,First Name, “Tom”; Last Name, “Jones” Anyassistance will be greatly appreciated!

[JoeM]

FirstName: Left([NameField],InStr([NameField]," ")-1)
LastName: Mid([NameField],InStr([NameField]," ")+1)

[djclntn]

Thanks Je! One more question, say I have the names 'yearsborn "1968" can I create a field ageborn from the 'yearsborn' field?

[JoeM]

Can you post an example of the actual data layout and expected result.

[djclntn]

Never mind,, I figured it out. Thanks again Joe!