I have a list in Excel from A1:A100 with names like the ones mentioned
below:

Michelle Fooo )
Myhaass Smith )


I want to parse them using string functions to the following format




Any ideas how to do this using a formula?

Thanks in advance
Michael