Removing certain text in several cells

**cloudwalking** · 01-03-2013, 01:55 PM

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)

**martindwilson** · 01-03-2013, 01:56 PM

find (gb) replace with nothing

**Kevin UK** · 01-03-2013, 02:02 PM

Hi cloudwalking

Or assuming data is column A, in B1 and copy down:

Formula:

Please Login or Register  to view this content.

**cloudwalking** · 01-03-2013, 02:06 PM

thank you to both!

**oeldere** · 01-03-2013, 02:23 PM

And with text to column, you can get the "other" bracketed codes "(IRE)" in a seperated cell (if wanted).

Then you can also select (filter) on this item.