How do I extract "John" from "John and Sally"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I eslect only the first name in a field that has two names, such as
John and Sally
 
Please search for previous posts before adding a new thread. From a
previous post, I found the following posted by John Spencer...

The expression below will work as long as the string has a space in it.

Trim(Left([TheString],Instr(1,[TheString]," ")))


If your string might be blank (or null) or have no space in it, try
Trim(Left([TheString],Instr(1,[TheString] & " "," ")))
 
You must log in or register to reply here.

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

Find Values in Excel Document and add together 2
Combining duplicates into a single multi value field 8
Odd query behavior 3
Delete all instances of a records in table based on value in list 3
Creating Entries 1
reflecting values in a column into a row 1
formula to copy contents of a column of cells into a row? 4
how do I invert all of my cell entries ? 4

Back
Top