Need a macro to do the following, to look for a name in column G3, worksheet "role" and if the name has (232232) number at the of a persons name then remove the bracket + the numbers betwwen the brackets....for example
1. Joe Doe(32213) replace with Joe Doe (no space between surname and open bracket.
2. Joe Doe (32322) replace with Joe Doe space after surname
these are the only two cases that can exist.