Question
February 20, 2013 at 06:55 AM
answerman

Why is this returning this result?

by answerman . Updated 13 years, 6 months ago

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)

This discussion is locked

All Comments