更小的版本:
=SUBSTITUTE(PROPER(TRIM(A1))," ","")
我们只需使用PROPER
为大写和TRIM
and SUBSTITUTE
删除空格。
如果我们想要小驼峰命名法,
By just REPLACE
将第一个字符改成小写,我们有:
=REPLACE(SUBSTITUTE(PROPER(TRIM(A1))," ",),1,1,LEFT(LOWER(TRIM(A1))))
使用正则表达式:
=REGEXREPLACE(REGEXREPLACE(PROPER(A1),"\s*",),"^(\w)",LEFT(LOWER(TRIM(A1))))
=LOWER(LEFT(TRIM(A1)))®EXREPLACE(PROPER(TRIM(A1)),"(\w|\s)(\w*)","$2")