難不成這樣？：
分位：
=IF(MID(RIGHT(A2,2),1,1)="零",0,"")&IF(MID(RIGHT(A2,2),1,1)="壹",1,"")&IF(MID(RIGHT(A2,2),1,1)="貳",2,"")&IF(MID(RIGHT(A2,2),1,1)="三",3,"")&IF(MID(RIGHT(A2,2),1,1)="肆",4,"")&IF(MID(RIGHT(A2,2),1,1)="伍",5,"")&IF(MID(RIGHT(A2,2),1,1)="陸",6,"")&IF(MID(RIGHT(A2,2),1,1)="柒",7,"")&IF(MID(RIGHT(A2,2),1,1)="捌",8,"")&IF(MID(RIGHT(A2,2),1,1)="玖",9,"")
角位：
=IF(MID(RIGHT(A2,4),1,1)="零",0,"")&IF(MID(RIGHT(A2,4),1,1)="壹",1,"")&IF(MID(RIGHT(A2,4),1,1)="貳",2,"")&IF(MID(RIGHT(A2,4),1,1)="三",3,"")&IF(MID(RIGHT(A2,4),1,1)="肆",4,"")&IF(MID(RIGHT(A2,4),1,1)="伍",5,"")&IF(MID(RIGHT(A2,4),1,1)="陸",6,"")&IF(MID(RIGHT(A2,4),1,1)="柒",7,"")&IF(MID(RIGHT(A2,4),1,1)="捌",8,"")&IF(MID(RIGHT(A2,4),1,1)="玖",9,"")
個位：
=IF(MID(RIGHT(A2,6),1,1)="零",0,"")&IF(MID(RIGHT(A2,6),1,1)="壹",1,"")&IF(MID(RIGHT(A2,6),1,1)="貳",2,"")&IF(MID(RIGHT(A2,6),1,1)="三",3,"")&IF(MID(RIGHT(A2,6),1,1)="肆",4,"")&IF(MID(RIGHT(A2,6),1,1)="伍",5,"")&IF(MID(RIGHT(A2,6),1,1)="陸",6,"")&IF(MID(RIGHT(A2,6),1,1)="柒",7,"")&IF(MID(RIGHT(A2,6),1,1)="捌",8,"")&IF(MID(RIGHT(A2,6),1,1)="玖",9,"")
其他的類推，只改動RIGHT(A2,6)裏的參數為2，4，6，8，10，12，14，等等
但是那個人民幣符號實在不好辦，只限這三個函數。