能否将字符串中的数字表现成中文小写形式

57wk · 发表于 2024-7-15 07:11

如：车3进5——车三进五、前炮平6——前炮平六……

沈默00 · 发表于 2024-7-15 07:40

笨办法来一个
=SUBSTITUTES($F1,{"1","2","3","4","5","6","7","8","9"},{"一","二","三","四","五","六","七","八","九"})

咔咔乱坠 · 发表于 2024-7-15 08:35

1-9可用

=CONCAT(TEXT(MID(A1,ROW($1:99),1),"[DBNum1]0"))

复制代码

ww87725244 · 发表于 2024-7-15 23:05

来个长的

=CONCAT(IFERROR(MID("1一2二3三4四5五6六7七8八9九",FIND(MID(A1,ROW(1:4),1),"1一2二3三4四5五6六7七8八9九")+1,1),MID(A1,ROW(1:4),1)))

57wk · 发表于 2024-7-16 08:10

谢谢楼上的朋友！
我用的是2010版的，上述函数均“未定义”。

57wk · 发表于 2024-7-19 23:22

用这公式可处理：“=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F1,"1","一"),"2","二"),"3","三"),"4","四"),"5","五"),"6","六"),"7","七"),"8","八"),"9","九")。但不知可否简化？
请朋友们指点。谢谢！

我的城市你来过 · 发表于 2024-7-20 19:17

=CONCAT(TOCOL(VSTACK(REGEXP(F10,"\p{Han}"),NUMBERSTRING(REGEXP(F10,"\d"),1))))

		自动登录	找回密码
密码			免费注册

[求助] 能否将字符串中的数字表现成中文小写形式