Extract middle initial

rocket0612 · Jul 4, 2005

If in cell A1 is a name in the format "John J Jackson", how can I retur
the middle inital in A2?

thank

Bob Phillips · Jul 4, 2005

Easiest way is Data>Text To Columns with a space separator

BenjieLop · Jul 4, 2005

rocket0612 said:
If in cell A1 is a name in the format "John J Jackson", how can I return
the middle inital in A2?

thanks

=MID(A1,FIND(\" \",A1)+1,1)

should be your formula.

Regards.

CLR · Jul 4, 2005

=MID(A1,FIND(" ",A1,1)+1,1)

Vaya con Dios,
Chuck, CABGx3

rocket0612 · Jul 5, 2005

thanks alot.

Bob, as the name is a variable your won't work but maybe I should have
said that!

thanks alot