Can VBA do this? When someone enters "ABC123" in cell A1, I would like it to automatically remove the "ABC", within the same cell. Currently, after all the data is entered, I strip it by using a formula in the B column.

=IF(LEFT(A1,3)="ABC",RIGHT(A1,LEN(A1)-3),A1)

I am also having to nest upto 7 IF statements to strip everything I do not want.


Thanks in advance for any help.