If its the only comma, use Edit 'Replace , Replace With Nothing
Replace All
If not,
=SUBSTITUTE(A1,RIGHT(A1,1),"")
Paste Special Values to lose the formula's
Regards,
Alan.
"mira" wrote in message
...
I am trying to remove a comma which happens to be the last character in the
cell. Does anyone know how to do this?