Excel Ad-Soyad Bölme |

19 Aralık 2017
emretalu
İşletim Sistemi/ Windows

Ad:

=LEFT(A2,FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))-1)

Soyad:

=TRIM(RIGHT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))