Return text between first and second space?

[CHC Consulting LLC]

What can I do to find what text is between 2 spaces.

For example, I need to return OPTE in a cell that contains Anaheim OPTE C. Edwards.

 

[AlphaFrog]

Try something like this...

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ", 100)),100,100))

Change the red 100 to 200 to get the 3rd word and to 300 to get the 4th word.

 

[CHC Consulting LLC]

Try something like this...

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ", 100)),100,100))

Change the red 100 to 200 to get the 3rd word and to 300 to get the 4th word.

Much Appreciated!!!