excel操作下劃線轉駝峰 文字拼接

336土豆快跑發表於2024-08-12

下劃線轉駝峰

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

文字拼接

=CONCAT(A1:H1)

相關文章