View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DianeandChipps DianeandChipps is offline
external usenet poster
 
Posts: 13
Default 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.