remove brackets from a cell

[Pauls123]

Hi,

As a result of copying and pasting etc, I have a bracketed number in a cell, eg, (10).

How can I make it just appear as 10.

Thanks, Paul

 

[jasonb75]

Select the range, press Ctrl H,

find what:- (

replace with:- leave empty.

Repeat for )

 

[Weaver]

Are the brackets part of the cell contents or as a result of cell formatting? Brackets can sometimes appear around numbers to indicate negative values.

If it's the former, you can get rid of the brackets easily using the replace function. Excel might still see the numbers as text but you can fix this if you run the 'text to columns' wizard after selecting the column with the data in it, then immediately clicking 'finish'

If the latter, set the cell format to 'general' or something else suitable.

 

[Pauls123]

Thanks Jason, but is there a formula I can use in another cell, purely to remove those brackets and just be left with the number, basically so I dont have to do anything additionally, Thanks, Paul

 

[Pauls123]

and just to go a bit further here, if I have a word with (A) after it, eg, excel (A). Can I put a formula into another cell, in order to remove that (A), and just be left with the word, excel.

Thanks again, Paul

 

[Weaver]

Here's a formula for the first part of your question

=--SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

Where A1 has (10) in it.

This should be okay for the second part

=TRIM(LEFT(A1,SEARCH("(",A1)-1))

 

[Weaver]

Actually, better use this for second part

=IF(ISERROR(SEARCH("(",A1)),A1,TRIM(LEFT(A1,SEARCH("(",A1)-1)))

Just in case there are no opening brackets in the cell