éè¦ä½¿ç¨å®ï¼
自定义函数吧
function del(cl as range)“Feather White2白羽毛2” 两个英文单词之间有空格的不行,变成“White2白羽毛2”
追答function del(cl as range)
dim reg as object
set reg=createobject("vbscript.regexp")
with reg
.pattern="^[A-Z a-z\d]+"
del=.replace(cl,"")
end with
end function
加个空格的判断就好了
“Feather White2白羽毛2” 两个英文单词之间有空格的不行,变成“White2白羽毛2”
追答若前面有空格,用以下公式:
=TRIM(MID(G3,MATCH(TRUE,MID(G3,ROW(INDIRECT("1:"&LEN(G3))),1)>="吖",),99))