View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hydbloos@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Get Title, Forename(s) and Surname

Hello Everyone,

I have got a field that has the full name of a person.

I am basically looking for a code (or ideas) to get the Title,
Forname(s) and Surname from the supplied full name.

Some examples:
1. Input: Mr Lucas
Output:
Title: "Mr"
Forename: ""
Surname: "Lucas"

2. Input: John Lucas
Output:
Title: ""
Forename: "John"
Surname: "Lucas"

3. Input: John Lewis Lucas
Output:
Title: ""
Forename: "John Lewis"
Surname: "Lucas"

4. Input: Mr John Lucas
Output:
Title: "Mr"
Forename: "John"
Surname: "Lucas"

5. Input: Mr John Lewis Lucas
Output:
Title: "Mr"
Forename: "John Lewis"
Surname: "Lucas"

Can someone suggest some ideas of it would be great if you have a code
that I can use.

Many Thanks,
Nevaank