Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting by surname when first name and surname are in the same cel | New Users to Excel | |||
Split first name and Surname | Excel Programming | |||
Change around surname and name | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Name Surname combination | Excel Programming |