| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
=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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
| How do I extract 3 middle results and average them in excel | Excel Worksheet Functions | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| Extract number in middle of cell | Excel Worksheet Functions | |||
| Extracting Last Name and First Initial | New Users to Excel | |||
Linear Mode
