trying to write a regex for use in excel
at the moment i have tried
\[.*\]
and
\[*\] the idea being it will be used to replace [85%] and [125%] in
Mary Jones[85%], Max Smith, John James[125%]
but what it does is find
[85%], Max Smith, John James[1255] i.e all in the first[ and last]
any advice would be appreciated thanx
ah i think i cracked it
[\[{0-9}%\]]