Numbers after specific text
The following data is entered in a cell:
P5-MPC FT 18, P5-MPC FT 25, P5-MPC FT 30, P5-MPC FT 35,P5-MPC PTR 1, P5-MPC
PTF 9
The P5-MPC text is irrelevent. I need the #'s after each FT, after each PTR
and after each PTF, so that my resulting data would be:
FT18
FT25
FT30
FT35
PTR1
PTF1
Could the above be returned in 6 different cells even if the original data
is all in one cell?
Ultimately I need to count all the FTs, all the PTRs, & all the PTFs.(
FT=4,PTR=1, PTF=1)
Any help would be greatly appreciated.
Thanks,
Steve
|