excel操作下划线转驼峰 文字拼接

下划线转驼峰

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

文字拼接

=CONCAT(A1:H1)
posted @ 2024-08-12 16:38  336土豆快跑  阅读(135)  评论(0)    收藏  举报