Tách họ: =LEFT(E2,FIND(" ",E2,1)-1)
Tách tên lót:
=TRIM(REPLACE(LEFT(E2,FIND("*",SUBSTITUTE(E2," ","*",LEN(E2)-LEN(SUBSTITUTE(E2," ",""))))-1),1,FIND(" ",E2,1)-1,""))
Tách tên:
=RIGHT(E2,LEN(E2)-FIND("*",SUBSTITUTE(E2," ","*",LEN(E2)-LEN(SUBSTITUTE(E2," ","")))))
![](http://pinterest.com/pin/create/button/?url=https://office7x.blogspot.com/2017/09/cach-tach-ten-ho.html&media=https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhh9ug38RMSq_gl4egtr-4uxy_GuRvgr_In0QC9h9OEvPGKxt-uaqocBt0bNC8U8M8PKbLeesIg_1IaVwLikdlhwN2COkLULrs7H_UgVq35HFcqE2k0EI_V3LUrt4MqPzq9b6Th8h5eeLyc/s72-c/7359933.jpg&description= Tách họ : =LEFT(E2,FIND(" ",E2,1)-1) Tách tên lót: =TRIM(REPLACE(LEFT(E2,FIND("*",SUBSTITUTE(E2," ",...){kind=link}
0 nhận xét:
Đăng nhận xét