Removing last 2 characters of a specific cell

[Masoud00]

Background: I have entry level VBA knowledge and am working with a macro to prepare client files daily. I am looking for a VBA code to remove the last 2 digits of client ID numbers found on cell C23. (multiple unique IDs will be encountered per day so the code must be universal in its application to removing the last 2 digits always in cell C23). Thank you

 

[alansidman]

Option Explicit

Sub C23()
Range("C23") = Left(Range("C23"), Len(Range("C23")) - 2)
End Sub