Extract middle initial

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

thanks

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

--
HTH

Bob Phillips

"rocket0612" <rocket0612.1rnhml_1120489533.2509@excelforum-nospam.com> wrote
in message news:rocket0612.1rnhml_1120489533.2509@excelforum-nospam.com...
>
> If in cell A1 is a name in the format "John J Jackson", how can I return
> the middle inital in A2?
>
> thanks
>
>
> --
> rocket0612
> ------------------------------------------------------------------------
> rocket0612's Profile:
http://www.excelforum.com/member.php...o&userid=19492
> View this thread: http://www.excelforum.com/showthread...hreadid=384315
>

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

Vaya con Dios,
Chuck, CABGx3



"rocket0612" <rocket0612.1rnhml_1120489533.2509@excelforum-nospam.com> wrote
in message news:rocket0612.1rnhml_1120489533.2509@excelforum-nospam.com...
>
> If in cell A1 is a name in the format "John J Jackson", how can I return
> the middle inital in A2?
>
> thanks
>
>
> --
> rocket0612
> ------------------------------------------------------------------------
> rocket0612's Profile:
http://www.excelforum.com/member.php...o&userid=19492
> View this thread: http://www.excelforum.com/showthread...hreadid=384315
>

thanks alot.

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

thanks alot