"Yue Lou" wrote:
> I am a foreigner so I know little about the name in this excel. > For example ,there is a name called "Van Impe, Mrs. Jean Baptiste (Rosalie Paula > Govaert)".> What is her surname? Is there any rule to find the surname?
Her surname is "Van Impe".
In all cases, it's everything before the comma.
Think of it as a field with two subfields: FamilyName, PersonalName
And we know of a number of commands for dealing with fields!