Tách Họ, Tên, Chữ lót trong Excel
HỌ: =LEFT(B2,FIND(" ",B2,1)-1)
Đệm: =TRIM(REPLACE(LEFT(B2,FIND("*",SUBSTITUTE(B2," ","*",LEN(B2)-LEN(SUBSTITUTE(B2," ",""))))-1),1,FIND(" ",B2,1)-1,""))Tên: =RIGHT(B2,LEN(B2)-FIND("*",SUBSTITUTE(B2," ","*",LEN(B2)-LEN(SUBSTITUTE(B2," ","")))))
