Extract first name in a string

G

Guest

Hi,
If i have a string, a name, "James taylor" how do I use trim to extract the
first name "James"
 
J

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] & " "," ")))


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Extracting First Name 12
Spliting a string 3
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Extracting first 1 or 2 nymbers 4
Extracting the last word from a string. 2
Extract data from Tables (in VB) 1
Excel Extract Text from decimal separated string 6
Access to split First and Last name 0

Top