Excel(2)——字段命名(大写下划线分词)转 驼峰命名

干货:

(帕斯卡)

=LEFT(C251,1)&MID(SUBSTITUTE(PROPER(C251),"_",""),2,100)

(驼峰)

=LOWER(LEFT(C251,1))&MID(SUBSTITUTE(PROPER(C251),"_",""),2,100)

posted @ 2018-07-21 11:57  xu_shuyi  阅读(1062)  评论(0编辑  收藏  举报