=REGEXEXTRACT(B3,"[^０-９0-9]*")

=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…

シート１ A列検索したい番号 B自動入力=SUBSTITUTE(A2,"-","") C列2=IFERROR(VLOOKUP(LEFT(B2,2)&"*",禁止リスト!$L$3:$M$11,2,FALSE),"") D列3=IFERROR(VLOOKUP(LEFT(B2,3)&"*",禁止リスト!$L$13:$M$24,2,FALSE),"") E列5=IFERROR(VLOOKUP(LEFT(B2,5)&"*",…