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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=384315

Easiest way is DataText To Columns with a space separator

--
HTH

Bob Phillips

"rocket0612" wrote
in message ...

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

rocket0612 Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=384315

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

Vaya con Dios,
Chuck, CABGx3



"rocket0612" wrote
in message ...

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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=384315