例:A1是心适贝贝JX3215双面和尚衣(鱼水/果绿/浅黄)
我想要实现B1是心适贝贝双面和尚衣(鱼水/果绿/浅黄)c1是JX3215
各位大师 麻烦帮下忙
不行啊 实现不了啊
追答在我的电脑上可以实现,需要帮忙可以HI我
我不会
追答打开你这个EXCEL文件,按Alt不动,再按F11,打开代码编辑器,插入一个模块后输入下面的代码后,在B1中输入=tqsz(a1),在C1中输入=tqwz(a1),回车就可以了。代码:
Function tqsz(rg As Range)
Dim st, str As String
st = ""
For i = 1 To Len(rg)
str = Mid(rg, i, 1)
If (str >= "0" And str = "a" And str = "A" And str = "0" And str = "a" And str = "A" And str <= "Z")) Then
st = st & str
End If
Next
tqwz = st
End Function