Extract middle initial

[rocket0612]

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]

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

 

[BenjieLop]

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]

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

Vaya con Dios,
Chuck, CABGx3

 

[rocket0612]

thanks alot.

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

thanks alot