In col A I have 17 character code and in Col B I do a replace 11 characters
so just the first 6 characters are left and in Col B
Col A Col B
abcdefXXXXXXXXXXX abcdef
In col C I want to countif(b1:b100,"abcdef")
I will get 0 unless I go back and type in every cell in col B and then the
formula counts the correct number of matches.
Any help as to how I can correct this without retyping each cell in Col B? I
have anywhere from 1000 - 9000 cells to match and count.
Thanks in advance for any help.

--
Ron