CALC Find "[12]"

Have several [12], [3], [45] in a CALC spreadsheet, different cells.

Want to delete both brackets and numbers enclosed.

Have tried [], "[]" (with quotes), [**], […] and several others

Any Ideas for me to try?


with Regular expressions.


in Edit -> Find and Replace... try;

Find \[\d+\] ( \[ and \] is required to disable (mask) the special meaning of square brackets, when using regular expressions)
Other Options [x] Regular expressions

Hope that helps.

Worked GREAT!

If the answer works for you, please consider to click the check mark (:heavy_check_mark:) next to the answer. (That’s the way to indicate a correct answer, there is no need to close a question). Thanks in advance …