Separating First and Last names in one field

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

How do I separate a field that contains 2 words (ie first
name and last name) into 2 different fields.

The words are divided by a space in the field.

I need to be able to do this in a query.

Thank you in advance for your help.
 
Try the following:

FirstName: Left([FullName], InStr([FullName], " ") -1)

LastName: Mid([FullName], InStr([FullName], " ") +1)


hth,
 
Please do a search. This question is asked and answered almost weekly.


How do I separate a field that contains 2 words (ie first
name and last name) into 2 different fields.

The words are divided by a space in the field.

I need to be able to do this in a query.

Thank you in advance for your help.
 
Back
Top