=IF(ISNUMBER(MATCH(LEFT(A2,1),一文字姓,0)),REPLACE(A2,2,0," "),IF(ISNUMBER(MATCH(LEFT(A2,3),三文字姓,0)),REPLACE(A2,4,0," "),REPLACE(A2,3,0," "))) 【自動空白】住所編A郵便番号入力 B住所全部入力=VLOOKUP(A2,Sheet4!A:C,2,0) C=VLOOKUP(C2,Sheet4…