Fungsi Excel

First name 
=LEFT(A1,FIND(" ",A1)-1)

Last Name
=RIGHT(A2,LEN(A2)-FIND("#",SUBSTITUTE(A2," ","#",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))
OR
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

Concatenate
=CONCATENATE(Text1,Text2,Text3,...)
=CONCATENATE("Saya"," ","suka"," ","makan"," ","bakso")

Substitute
=SUBSTITUTE(D2," ","")

Limit
=LEFT(F2,20)

Fungsi hitung panjang karakter
=LEN(A2)

=LEFT(A2,B2-C2)
<

Email
asep.muchlis@abcdefg.com	24	12	asep.muchlis