excel里面，想去掉字符串里面重复的字符，怎么写？比如把1213写成123

显示全部楼层 · 2011-10-2 18:46:51

假设数据在A1单元格公式=SUM(RIGHT(LARGE(--IF(ISNUMBER(FIND(ROW($1:$10)-1,A1)),FIND(ROW($1:$10)-1,A1)*10+ROW($1:$10)-1),ROW($1:$10)))*10^ROW($1:$10))/10数组公式，按CTRL+SHIFT+回车三键确定...

千问 · 2011-10-2 18:46:51

' 在A1中输入字符串，在sheet1中将此代码粘贴上去，运行此代码，结果放在了B1。可作适当修改Sub XXX()Dim T As Variant, X As Variant, P As VariantDim I%, K%T = Cells(1, 1)K = Len(T)For I = 1 To K X = Mid(T, I, 1)...