View Single Post
  #1   Report Post  
rocket0612
 
Posts: n/a
Default 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