In an Excel spreadsheet I have a column containing first name, sometimes an initial (or two), then a surname then in brackets a date of birth. How can I extract the surname?
e.g. one row might be John A Smith (01/01/1990)
The next might be John A Smith (02/02/1991) and the next
John Smith (03/03/1992)
All help very gratefully received