The titles are titles, they are just lables, the outcome is like:
I know the functions like Left(), Right(), but I don't know how to get this done. Please help. Thanks.
Do you really want to include the titles with the names?
Are there always a first name, space, and last name?
Have you looked into the string functions like Instr(), Left(), Right() , and Mid()?
What have you tried so far?
Duane Hookom, MVP
Date: Wed, 6 Apr 2016 12:00:49 +0800
Subject: [MS_AccessPros] Split a text field into two text fields.
I have a text field called "PassangerFullName", for example:
PassangerFullName: Jack Smith
My question is: how to split this "PassangerFullName" into two text field,namely "FirstName: Jack" and "FamilyName: Smith"? Thanks in advance.
Posted by: "email@example.com" <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!