excel常用公式

转为小驼峰

=LOWER(LEFT(SUBSTITUTE(PROPER(SUBSTITUTE(LOWER(A2),"_"," "))," ",""),1))&MID(SUBSTITUTE(PROPER(SUBSTITUTE(LOWER(A2),"_"," "))," ",""),2,LEN(A2))

vlookup

=VLOOKUP(C2,B2:B40,1,FALSE)
posted @ 2025-05-11 22:10  fight139  阅读(13)  评论(0)    收藏  举报