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?
TNX
⌡im
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?
TNX
⌡im
\[[0-9]*\]
with Regular expressions.
Hello
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!
Thanks,
⌡im
If the answer works for you, please consider to click the 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 …