I have a sample (Three excel columns) :
M2 B7 41087A2000
M2 B7 41087B4000AD030
M2 B7 41087B2000
M2 B7 41087C3000
I want to know how many instances number 2, 3 and 4 i have. Instance number two (2000), number three (3000) and number four (4000) which are bold in my sample.
How can i replace the letter A,B,C,D,E… before the instance ?
.Contain(“41097” + - + “2000”)