Hi Guys, how are you today?
So, in short, I have the following set of strings:
Ronaldo, (Portugal) Christiano
Beckam, David (England)
and I want to receive the following:
Christiano Ronaldo
David Beckam
I am aware how to do it without the parenthesis, just the flip:
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))
I know also how to show only the text in the parenthesis:
=MID(L15,FIND("(",L15)+1,(FIND(")",L15)-FIND("(",L15))-1)
Any idea how to remove the parenthesis and the text inside and then to flip first name and last name?
Bookmarks