(资料图片)

1、这个做起来思路相对容易，但公式较长，编辑过程中容易出错。

2、对于亿、万、元、角、分公式较简单，但对于万前的千、百、十和万后的千、百、十要再加以判断，公式就变得复杂了。

3、提取出大写之后，再把大写转化成小写。

4、例设大写金额放在A2单元格，相应公式如下：亿=IFERROR(MATCH(IFERROR(IF(FIND("亿",$A$2),MID($A$2,FIND("亿",$A$2)-1,1),""),""),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)千（万）=IFERROR(MATCH(IFERROR(IF(FIND("万",$A$2)>0,IF(FIND("仟",$A$2)0,IF(FIND("佰",$A$2)0,IF(FIND("拾",$A$2)0,FIND("仟",MID($A$2,FIND("万",$A$2),22)),"")-1,1),IFERROR(MID($A$2,FIND("仟",$A$2)-1,1),"")),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)百=IFERROR(MATCH(IFERROR(MID(MID($A$2,FIND("万",$A$2),22),IF(FIND("万",$A$2)>0,FIND("佰",MID($A$2,FIND("万",$A$2),22)),"")-1,1),IFERROR(MID($A$2,FIND("佰",$A$2)-1,1),"")),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)十=IFERROR(MATCH(IFERROR(MID(MID($A$2,FIND("万",$A$2),22),IF(FIND("万",$A$2)>0,FIND("拾",MID($A$2,FIND("万",$A$2),22)),"")-1,1),IFERROR(MID($A$2,FIND("拾",$A$2)-1,1),"")),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)元=IFERROR(MATCH(IFERROR(IF(FIND("元",$A$2),MID($A$2,FIND("元",$A$2)-1,1),""),""),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)角=IFERROR(MATCH(IFERROR(IF(FIND("角",$A$2),MID($A$2,FIND("角",$A$2)-1,1),""),""),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)分=IFERROR(MATCH(IFERROR(IF(FIND("分",$A$2),MID($A$2,FIND("分",$A$2)-1,1),""),""),{"壹","贰","叁","肆","伍","陆","柒","捌","玖"},0),0)。

本文分享完毕，希望对你有所帮助。