想达到的是E1的效果
A1 | aa_bb_cc |
---|---|
B1 | =PROPER(A1) |
C1 | =SUBSTITUTE(B1,"_","") |
D1 | =LOWER(LEFT(C1,1))&RIGHT(C1,LEN(C1)-1) |
E1 |
E1实现公式
=LOWER(LEFT((SUBSTITUTE((PROPER(A1)),"_","")),1))&RIGHT((SUBSTITUTE((PROPER(A1)),"_","")),LEN((SUBSTITUTE((PROPER(A1)),"_","")))-1)
想达到的是E1的效果
A1 | aa_bb_cc |
---|---|
B1 | =PROPER(A1) |
C1 | =SUBSTITUTE(B1,"_","") |
D1 | =LOWER(LEFT(C1,1))&RIGHT(C1,LEN(C1)-1) |
E1 |
E1实现公式
=LOWER(LEFT((SUBSTITUTE((PROPER(A1)),"_","")),1))&RIGHT((SUBSTITUTE((PROPER(A1)),"_","")),LEN((SUBSTITUTE((PROPER(A1)),"_","")))-1)