Hi guys

I have some text (1000's of lines) that have some numbers after the text displayed in brackets, for example

Orange Box (36982)
Yellow Ball (4876)
Red (214)
Green Top Hat (94)
Blue Sky (1)

What I need is a formula to remove the brackets and numbers within them, plus also the space before the ( bracket. So the result should only be the text itself, i.e.

Orange Box
Yellow Ball
Red
Green Top Hat
Blue Sky

Does anyone know how I can achieve this via a formula please.

Thanks

GW