Finding string within string
Posted on 2013-10-25
I need to get part of a string within a string in a cell.
The whole string is for example: 114567 5174 M11001
I want the middle part 5174.
I know that there are several ways to do this but I want the smartest :-)
The string can vary in length, but the middle part is always surrounded by 5 blanks.