Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |