excel 大写转驼峰写法 USER_ID --> userId

excel 大写转驼峰写法 USER_ID --> userId

方法一，两部操作，需要替换$B2, $C2

=SUBSTITUTE(PROPER(SUBSTITUTE($B2,"_", " "))," ","")

=LOWER(LEFT($C2,1))&RIGHT($C2,LEN($C2)-1)

方法二，一步操作，需要替换$B2

=LOWER(LEFT($B2,1))&RIGHT(SUBSTITUTE(PROPER(SUBSTITUTE($B2,"_", " "))," ",""),LEN(SUBSTITUTE(PROPER(SUBSTITUTE($B2,"_", " "))," ",""))-1)