Hi,
Would anyone please be able to help me to extract surnames from a name field where the values are in the format of initials for fornames followed by the surname?
For example, column A in my spreadshet has values as below:
C Black
C R Dobbins
J Hartley
K Jones
K M Wilkins
N Armstrong
The surname extraction should look like:
Black
Dobbins
Hartley
Jones
Wilkins
Armstrong
I have been trying to get a formula to work that measures the field length then looks for the 1st space from the right in the field then uses the RIGHT function to get the surname but just cannot get it to work.
Any advice most appreciated
Thx
Would anyone please be able to help me to extract surnames from a name field where the values are in the format of initials for fornames followed by the surname?
For example, column A in my spreadshet has values as below:
C Black
C R Dobbins
J Hartley
K Jones
K M Wilkins
N Armstrong
The surname extraction should look like:
Black
Dobbins
Hartley
Jones
Wilkins
Armstrong
I have been trying to get a formula to work that measures the field length then looks for the 1st space from the right in the field then uses the RIGHT function to get the surname but just cannot get it to work.
Any advice most appreciated
Thx