Right Function

  • Thread starter Thread starter MJOHNSON
  • Start date Start date
M

MJOHNSON

I have a field that contains a first and a last name.
How do I pull out just the last name from the field. I
think I can do it using the Right Function, but I am not
quite sure how to do this. Please advise.
 
I have a field that contains a first and a last name.
How do I pull out just the last name from the field. I
think I can do it using the Right Function, but I am not
quite sure how to do this. Please advise.
Click to expand...

If ALL of data in the field is similar to
FirstName LastName
i.e. a single space between them,
Use:

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