Lahtris B3 on antud
isiku ees- ja perenimi " Ilmar Tamm ".
Mis valemiga saab
isiku nimi kujul " I. Tamm "?

Question

Lahtris B3 on antud
isiku ees- ja perenimi " Ilmar Tamm ". 
 Mis valemiga saab
isiku nimi kujul " I. Tamm "?

Accepted Answer

=LEFT(B3)&".
"&RIGHT(B3;LEN(B3)-FIND(" ";B3))

Answer

=LEFT(B3)&" "&RIGHT(B3;LEN(B3)-FIND(" ";B3))

Answer

=LEFT(B3)&RIGHT(B3;LEN(B3)-FIND("
";B3))

Answer

=LEFT(B3)+RIGHT(B3;LEN(B3)-FIND("
";B3))

Answer

=LEFT(B3)&"."&RIGHT(B3;LEN(B3)-FIND("
";B3))

Crowdly