=SUBSTITUTE(LEFT(A1, FIND(" ", A1)-1)," "," ") 名(スペースの右側) =RIGHT(A1, LEN(A1)-FIND(" ", A1)) =TRIM(JIS(RIGHT(A1, LEN(A1)-FIND(" ", A1))) =SUBSTITUTE(RIGHT(A1, LEN(A1)-FIND(" ", A1))," "," ") 住所のスペースより前を取り出す =SUBSTITUTE(A1," ","...