I have a column that is not consistent in the way data stored:

75 F1 Automatic
100 M1 Manual
94.02 C1 As requested
Medicare Fac Emp 105% T4
Medicare 105% T4 - Bilateral

All I need is the F1, M1, C1, T4, T4 in the next column.

Thanks

This works somewhat I believe.

=IF(ISNUMBER(VALUE(MID(A2,SEARCH(" ?? "," "&A2&" "),2))),MID(A2,SEARCH(" ??
"," "&A2&" ",SEARCH(" ?? "," "&A2&" ")+1),2),MID(A2,SEARCH(" ?? "," "&A2&"
"),2))

However, if there is more than one 2 digit word (or number) preceding the
value you're looking for, it won't work. However, you could continue the
pattern that the formula uses to counter that.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Max" wrote:

I have a column that is not consistent in the way data stored:

75 F1 Automatic
100 M1 Manual
94.02 C1 As requested
Medicare Fac Emp 105% T4
Medicare 105% T4 - Bilateral

All I need is the F1, M1, C1, T4, T4 in the next column.

Thanks