FF

If they are truly in brackets then you could do a replace (EditReplace) and
then use (m) in the 'what' box and nothing in the 'replace with' box

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"FF" wrote in message
...
Hi, I got some data from somewhere , all the numbers has (m) in the end
,for
example: 123(m) , 234(m), 456(m),...I wanna delete (m) from the end of all
to
use them in my calculations.Any suggestion?