removing brackets after a word in a cell

[Pauls123]

Hi. Using Excel 2010. Via a copy and paste from a web page a certain name at times comes up with brackets after it and a couple of letters in the bracket. EG.

Rolling Pin (NZ)

I only want this name to appear as "Rolling Pin"

Regards, Paul

 

[VoG]

Try

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

 

[Pauls123]

Hi Peter and thanks for your reply. I just tried that and it worked, BUT. In my case only sometimes there are brackets after names, not always.

So I am looking for a formula that will located these brackets when they appear and remove them.

Regards, Paul

 

[VoG]

Try

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

 

[Pauls123]

Hi Peter,

You are brilliant, I am impressed. Thanks again, Paul