Thanks Pats,
The spreadsheet was generated from another program so the values weren't
centered in the cell...I added asterisks "*100A*" to the formula and it
works..

"Pats" wrote:

I created a workbook and entered some dummy text values, such as 100A, 110A,
1201
Then I used =COUNTIF(A1:A3,"100A") and it returned 1, which is correct.

"Vegs" wrote:

I need to count numbered text, such as, "100A" in a column.