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.
Bookmarks