Hi Steve
you can use the COUNTIF function
=COUNTIF(A1:A10,"* FT *")
=COUNTIF(A1:A10,"* PTF *")
Cheers
JulieD
"Steve" wrote in message
...
The following info is imported into one cell.
P5-MPC FT 81,
P5-MPC FT 82,
P5-MPC FT 83,
P5-MPC FT 93,
P6-PPDMO PTF 4,
P6-PPDMO PTF 16
I need to count how many FT's are in the cell, and how many PTF's are in
the
cell. The above data will vary in different cells, with up to a
combination
of possibly 15 total FT's & PTF's in the various cells.
Thanks,
Steve
|