赵四18430849383刘能13844039570 取“赵四” =LEFT(A1,LENB(A1)-LEN(A1)) 取“18430849383” =RIGHT(A1,2*LEN(A1)-LENB(A1))