I knew this had to be easy. That's why I could never find it in the books.
Rowan, Thank you very much!

NotAnExpert, aka MindTheGaps!

"Rowan" wrote:

If you use the Value property you can just replace the old value with the new
one e.g.

ActiveCell.Value = Right(ActiveCell.Value, 3)

Regards
Rowan