转载自:《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)
效果图:
本文标题:Excel实现_数据库下划线字段转驼峰命名
本文链接:https://www.haomeiwen.com/subject/iksjpktx.html
网友评论