用EXCEL实现 数据库下划线字段转驼峰命名
程序员文章站
2023-12-23 12:46:34
...
想达到的是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)