One way:

=LEFT(TRIM(A1),3)&IF(ISERR(FIND(" ",TRIM(A1))), "",
MID(TRIM(A1),FIND(" ", TRIM(A1))+1,2) &
IF((LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ","")))1, MID(TRIM(A1),
FIND("^",SUBSTITUTE(TRIM(A1)," ","^",2))+1,1),""))



In article ,
"Mirsten Choiple" wrote:

Many thanks for your help.

In the case of a title with only two words (eg Madam Bovary).

The desired result would be (eg MadBo).

Is that a possibility?


"JE McGimpsey" wrote in message
...
One way:

=LEFT(TRIM(A1),3) & MID(Trim(A1), FIND(" ",TRIM(A1))+1,2) &
MID(TRIM(A1), FIND("^", SUBSTITUTE(TRIM(A1)," ", "^", 2))+1,1)