在已转换大写金额的前面加文字

更新时间2018-12-03 08:51:44

比如（已知：A1金额是小写16000，B2框公式=A1，金额变成大写壹万陆仟元整。）

怎么在已变成大写金额的前面增加文字。

="合计人民币："&IF(A2="","",IF(ROUND(A2,2)<0,"负","")&IF((ABS(ROUND(A2,2))-INT(ABS(ROUND(A2,2))))=0,TEXT(ABS(ROUND(A2,2)),"[DBNUM2]")&"元整",IF(INT(ABS(ROUND(A2,2))*10)-ABS(ROUND(A2,2))*10=0,TEXT(INT(ABS(ROUND(A2,2))),"[DBNUM2]")&"元"&TEXT((INT(ABS(ROUND(A2,2))*10)-INT(ABS(ROUND(A2,2)))*10),"[DBNUM2]")&"角整",TEXT(INT(ABS(ROUND(A2,2))),"[DBNUM2]")&"元"&IF(INT(ABS(ROUND(A2,2))*10)-INT(ABS(ROUND(A2,2)))*10=0,"零",TEXT(INT(ABS(ROUND(A2,2))*10)-INT(ABS(ROUND(A2,2)))*10,"[DBNUM2]")&"角")&TEXT(RIGHT(ABS(ROUND(A2,2)),1),"[DBNUM2]")&"分")))

在公式前等号的后面加上

“需要增加的文本”&