Reverse Find
This will work, if there are ALWAYS two blanks in the cell. It works
by nesting a Find within a Find, starting the outer Find using the
inner Find as a parameter. It subtracts that result from the overall
length of the string itself, adding 1 to account for the non-zero
start.
=LEN(A1)+1-FIND(" ",A1,FIND(" ",A1,1)+1)
|