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)
 

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

Spacing in Customer's Name 1
Multiple Commas 3
Function similar to "LEFT" 3
Three fields conditionally based on other fields 6
Splitting a Field Question 2
tie multiple values from second table to first table 1
help with finding lowercase characters in table 2
query to trim name field? 5

Back
Top