【Excel】住所の数字を漢字表記に変換
SUBSTITUTE関数を使用する
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(JIS(A1),”１”,”一”),”２”,”二”),”３”,”三”),”４”,”四”),”５”,”五”),”６”,”六”),”７”,”七”),”８”,”八”),”９”,”九”),”０”,”〇”)
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(JIS(A1),”１”,”一”),”２”,”二”),”３”,”三”),”４”,”四”),”５”,”五”),”６”,”六”),”７”,”七”),”８”,”八”),”９”,”九”),”０”,”〇”)
