Hi there,

I have a list (a portion copied below), and I wish to remove the "(GB)" only from these cells. The other bracketed codes "(IRE)" etc must remain. Is there a way of doing this without manually deleting the text per cell (I have 15,000 in the column).

many thanks!

Adam de Beaulieu (USA)
Addazero (GB)
Addiction (GB)
Addictive Dream (IRE)
Addikt (IRE)
Address Unknown (GB)
Adeem (USA)
Adelar (GER)
Adelindus (GB)
Adeste (GB)
Adili (IRE)
Adios Alonso (IRE)
Adios Saffron (IRE)
Adiynara (IRE)
Admirable Duque (IRE)
Admiral Blake (GB)
Admiral Boom (IRE)