人民币填空

问题：按人民币金额将大写数字填于空处

 

解决：

{=TEXTJOIN({"拾","万","千","百","拾","元","角"},,TEXT(LEFT(RIGHT("　"&ROUND($A2,2)*100,9-COLUMN(A:H))),"[DBNum2]0"))&"分"}