VBA Remove anything in cell with brackets

[jamescooper]

Hello,

Is it possible to remove any text in a cell in brackets and the brackets please?

Many thanks.

 

[MARK858]

Possibly (untested so test on test data), for column B in the code below...

Sub RemBrackets()
   Columns("B:B").Replace What:="(*)", Replacement:="", LookAt:=xlPart
End Sub

 

[jamescooper]

Possibly (untested so test on test data), for column B in the code below...

Sub RemBrackets()
   Columns("B:B").Replace What:="(*)", Replacement:="", LookAt:=xlPart
End Sub

Thanks, that removes all the text in the cell with brackets, not just the text within brackets.

 

[MARK858]

Just tested it and it doesn't with my data. Can you post your data please.

 

[jamescooper]

Just tested it and it doesn't with my data. Can you post your data please.

Sorry you are correct. Thanks! It works.