Eliminating brackets and digits from a cell

[Pauls123]

Hi all,

In a cell that I have copied and pasted from the net the cell might read like this

Paul (10)

How can I just end up with the word "Paul" and totally eliminate the brackets and any digits that may be inside those brackets.

Regards, Paul

(Excel 2010)

 

[Aladin Akyurek]

Hi all,

In a cell that I have copied and pasted from the net the cell might read like this

Paul (10)

How can I just end up with the word "Paul" and totally eliminate the brackets and any digits that may be inside those brackets.

Regards, Paul

(Excel 2010)

Data | Text to Columns with ( as delimiter.

Or with a formula:

=TRIM(LEFT(A2,FIND("(",A2)-1))

 

[Pauls123]

Thanks Aladin, That worked perfectly, much appreciated,

Regards,
Paul

 

[Aladin Akyurek]

Thanks Aladin, That worked perfectly, much appreciated,

Regards,
Paul

You are welcome. Thanks for providing feedback.