It is not elegant, but seems to work
=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))=0,LEFT(A1),IF(LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))=1,LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1),LEFT(A1,1)&MID(A1,FIND("
",A1)+1,1)&MID(A1,FIND(" ",SUBSTITUTE(A1," ","",1))+2,1)))
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cardinal" <[email protected]> wrote in message
news:[email protected]...
>I have a column in Excel that has words in it like the following:
>
> Employee ID Format
> Company Options
> Processing Schedule
>
> Is there a function that would allow me to pull the first letter from
> each word.
> For example, Employee ID Format would give me EIF.
> Company Options would give me CO, etc.
> Thank you very much.
>