View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default Counting specific text in a cell

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