人民币填空

問題：按人民币金額将大寫數字填于空處

解決：

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