I have another excel puzzle that I am trying to solve.
I am trying to convert a name column into an email list. It sound simple enough, but there is a small twist, that is, some names included preferred first names in brackets. :P
This means that the preferred first names must be used.
Note: The names are strictly using the the examples in the spreadsheet, there are no other variations:
- Only first and last name, if a Western name.
- May include a preferred name in brackets, if the name is non-English.
Column A -> Desired name conversion
Bobby Robinson -> firstname.lastname@example.org
Lin Hon (Adam) Xiao -> email@example.com
In the example spreadsheet (tab = email addresses), I was able to each scenario separately, but not as a single unified formula.
Can anyone with better skills than me, help me with a solution?