Hi Steve

actually, i had another think about it and these formulas should work:
=(LEN(D35)-LEN(SUBSTITUTE(D35," FT ","")))/4
=(LEN(D35)-LEN(SUBSTITUTE(D35," PTF ","")))/5

Cheers
JulieD


"JulieD" wrote in message
...
Hi Steve

sorry missed the bit about it all being imported into one cell - any
chance you can use data / text to columns to split it up into mulitple
cells? if not, hopefully someone else will have an idea on how to do
this.

Cheers
JulieD

"Steve" wrote in message
...
I did try countif, but could not get it to work.
The information is all in one cell, in this case D35.

=COUNTIF(D35,"* FT *")

This formula is resulting in 1, not 5.

Thanks,

Steve

"JulieD" wrote:

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