Please help to remove numbers in brackets - abc (123)

[gwmbox]

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

[benishiryo]

hi GW, try:
=REPLACE(A1,FIND(" (",A1),255,"")

[jeffreybrown]

Another way...

=LEFT(A1,FIND("(",A1)-2)

[FDibbins]

if its just a once-off, use find and replace...find ( replace with "". repeat for )

[gwmbox]

Thanks guys for your solutions, all working perfect thanks

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

[ambharat]

tried the same and it gives me a "CIRCULAR REFERENCE WARNING" and once i click OK the value becomes ZERO "0". Also please suggest how i can apply this formula for a complete coloumn rather than going field by field.

[FDibbins]

ambharat...Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.