substitute()用法问题

风中飘雪 · 发表于 2002-10-17 15:43

在字数分割如：A3列：FMHP005 B3:=LEFT(A3,LEN(A3)-(SUM(LEN(A3)-LEN(SUBSTITUTE(A3,{"0","1","2","3","4","5","6","7","8","9"," "},""))))),其中SUBSTITUTE(A3,{"0","1","2","3","4","5","6","7","8","9"," "},"")我不知道是何意思？请大侠解答，谢谢！！！！(用,{"0","1","2","3","4","5","6","7","8","9"," "}数组的意思？？）

风中飘雪 · 发表于 2002-10-17 17:02

以下是引用Eraser2000在2002-10-17 16:19:58的发言： 就是把A3里所有的数字替换为空。

SUBSTITUTE(A3,{"0","1","2","3","4","5","6","7","8","9"," "},"") = FMHP5 ,好象不行，如果"0"与其它如"3"等对换又有新情况，看来只有请教版主了！！！

风中飘雪 · 发表于 2002-10-22 17:32

谢谢Emily！！！

Emily · 发表于 2002-10-18 18:14

Answer: http://club.excelhome.net/dispbbs.asp?boardID=3&RootID=38017&ID=38017

Eraser2000 · 发表于 2002-10-17 16:19

就是把A3里所有的数字替换为空。

Emily · 发表于 2002-10-17 16:39

SUBSTITUTE(A3,{"0","1","2","3","4","5","6","7","8","9"," "},"") = FMHP5 5 沒有變更

Eraser2000 · 发表于 2002-10-17 17:16

咦，但是它整个的函数公式是对的，怎么回事呢？这个SUBSTITUTE的函数好象是不能单独挑出来用的。

[此贴子已经被作者于2002-10-17 17:16:00编辑过]

znsong · 发表于 2017-3-25 14:59

的顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶

znsong · 发表于 2017-3-25 15:04

dddddddddddddddddddddddddddddddd

znsong · 发表于 2017-3-25 15:09

ddddddddddddddddddddd

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