| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking out 1st letter of names
I have been using the following formula to pick out the 1st letter of words.
=CONCATENATE(LEFT(A2,1),MID(A2,FIND(" ",A2)+1,1)) This has been working fine until there are 3 words in the cell. I would like to be able to pick out the 1st letter of each word in the cell no matter how many letters there are. Or to be able to pick out the 1st letter of the first and last words only. Words I am using a Project Manager Ongoing Specialist Support Monitoring and Evaluation I would like the adjacent cells to show: PM OSS ME Is this possible without going down the route of coding? Many thanks for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I include names in formula by picking up names from rows | Excel Worksheet Functions | |||
| Picking names from a hat in Excel? | Excel Discussion (Misc queries) | |||
| how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) | |||
| how do i sort a list from cells by picking a specific letter? | Excel Discussion (Misc queries) | |||
| FIRST letter of the names, mi and the whole last name. | Excel Discussion (Misc queries) | |||
Threaded Mode
