Excel实现_数据库下划线字段转驼峰命名
2020-10-10 本文已影响0人
单v纯微笑
转载自:《EXCEL实现_数据库下划线字段转驼峰命名》,感谢大神“icecoola_”
- 公式:
=LOWER(LEFT((SUBSTITUTE((PROPER(A1)),"_","")),1))&RIGHT((SUBSTITUTE((PROPER(A1)),"_","")),LEN((SUBSTITUTE((PROPER(A1)),"_","")))-1)
-
效果图:
效果图
转载自:《EXCEL实现_数据库下划线字段转驼峰命名》,感谢大神“icecoola_”
=LOWER(LEFT((SUBSTITUTE((PROPER(A1)),"_","")),1))&RIGHT((SUBSTITUTE((PROPER(A1)),"_","")),LEN((SUBSTITUTE((PROPER(A1)),"_","")))-1)
效果图: