What is wrong with this formula? I want to parse the “middle initial” out of this text string… what am I doing wrong? Text is in “K14″…..
TEXT: M. Jones RETURNING: es FORMULA USED: =RIGHT(K14,FIND(” “,K14)-1)