Hi, Can anyone help? I have a list of names
The list is in either two formats as listed in column A.
I need to eliminate the brackets and the text within it, and the two letters (FU) after it.
Bloggs, Joe (Joe) Fu
Bliggs, Jon Fu
The result I want in column B is
Bloggs, Joe
Bliggs, Jon
The list is in either two formats as listed in column A.
I need to eliminate the brackets and the text within it, and the two letters (FU) after it.
Bloggs, Joe (Joe) Fu
Bliggs, Jon Fu
The result I want in column B is
Bloggs, Joe
Bliggs, Jon