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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating Last Name, First Name into Two Fields 4
Separating Last Name, First Name into Two Fields 1
can i separate a name field into 2 separate columns? 8
Sorting by Last Name and then First Name in the Same Field 2
Spacing in Customer's Name 1
Split data in field on character return 0
breakdown adresses into separate fields 1
Convert Excel formula to Access query 7

Back
Top