triathlon_today
Registered User

Return Month value after second space

I am trying to return the 3 char month after the 2nd space in a character string. I have created it to return after the 1st space, but unsure how to get to the 2nd space. Any recommendations would be greatly appreciated.

String: 25 07 JUL BARNES & NOBLE #2615CINCINNATIOH $48.87

Formula: =MID(B27,FIND(" ",B27,1)+1,3)

Returns 07

How do I return "JUL"?

Thank you,
triathlon_today