watch If you have someone’s name in a cell and want to automatically extract initials, you can use binära optioner app LEFT, www opzionibinarie biz MID and go here FIND.

enter site As always when working with text cells, you can wrap with UPPER, LOWER or PROPER.

A B < B function >
1 Joe Bloggs JB http://www.youngasianescorts.co.uk/?baletos=%D8%A3%D8%B1%D8%A8%D8%AD-%D8%A3%D9%85%D9%88%D8%A7%D9%84-%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9-%D8%B9%D9%84%D9%89-%D8%A7%D9%84%D8%A5%D9%86%D8%AA%D8%B1%D9%86%D8%AA&76e=15 =LEFT(A1)&MID(A1,FIND(” “,A1)+1,1)
2 joe bloggs JB japanese culture dating =UPPER(LEFT(A2)&MID(A2,FIND(” “,A2)+1,1))

binäre optionen beliebteste trades I also found online  a funtion to manage three names – seems long so I imagine there is an easier way to do it, but it works:

A B < B function >
1 Joe John Bloggs JJB http://cougars-rencontres.fr/?fityue=d%C3%A9jeuner-rencontre-rive-sud&88f=8e =IF(LEN(A1)-LEN(SUBSTITUTE(A1,” “,””))=0,LEFT(A1,1),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(” “,A1,FIND(” “,A1)+1)+1,1)))