| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to pluck out initials of a 2 or 3 word name
For example, in A1 might be the name:
John Smith or John L. Smith or John Lee Smith I would like the result in cell B1 to be JS only Can a function be used? I have come up so far with "=MID(A1,1,1)&MID(A1,FIND(" ",A1)+1,1)" but it gives me the middle name initial and leaves out the last name initial any help much appreciated!! thank you |
|
#2
|
|||
|
|||
|
Craig,
=LEFT(A1,1) & MID(A1,IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)+1),1) All on one line. HTH, Bernie MS Excel MVP "Craig Brody" wrote in message ... For example, in A1 might be the name: John Smith or John L. Smith or John Lee Smith I would like the result in cell B1 to be JS only Can a function be used? I have come up so far with "=MID(A1,1,1)&MID(A1,FIND(" ",A1)+1,1)" but it gives me the middle name initial and leaves out the last name initial any help much appreciated!! thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link excel to word so excel changes appear in word? | Excel Discussion (Misc queries) | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
| Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Linear Mode
