如何将有数字、符号、字母的单元格内容第一个字母改为大写，而其余字母大小写不变 ...

尘心风舞

=CONCAT(INDEX(MID(IF({0,1},UPPER(A15),A15),ROW($1:$99),1),ROW($1:$99),1+(ROW($1:$99)=MIN(IFERROR(FIND(CHAR(ROW($65:$90)+{0,32}),A15),9999)))))

谷谷

好像不对哦~

鼓捣猫

=SUBSTITUTE(PROPER(SUBSTITUTE(A7,"-","- ")),"- ","-")

吉晋

复制的15行公式。。。。自己改下就好了。。。三键

拿鱼

=REPLACE(A2,MIN(IFERROR(FIND(CHAR(ROW($65:$90)+{0,32}),A2),"")),1,CHAR(MOD(MIN(IFERROR(FIND(CHAR(ROW($65:$90)+{0,32}),A2)/1%+ROW($65:$90),"")),100)))
=UPPER(LEFT(A2,MIN(IFERROR(FIND(CHAR(ROW($65:$90)+{0,32}),A2),""))))&MID(A2,MIN(IFERROR(FIND(CHAR(ROW($65:$90)+{0,32}),A2),""))+1,999)

阿凡哒

=PROPER(LEFT(A2,MIN(IFERROR(SEARCH(CHAR(ROW(A$65:A$90)),A2),99))))&MID(A2,MIN(IFERROR(SEARCH(CHAR(ROW(A$65:A$90)),A2),99))+1,99)

尛强

=VLOOKUP(FIND(999,SUM(IF(MID(A2,ROW($1:$9),1)>="A",9,1)*10^(9-ROW($1:$9)))),IF({1,0},ROW($1:$9),UPPER(LEFT(A2,ROW($1:$9)))&MID(A2,ROW($1:$9)+1,99)),2,)
三键输入公式

袁平

=LET(x,MIN(SEARCH(CHAR(ROW($65:$90)),A2&CONCAT(CHAR(ROW($65:$90))))),REPLACE(A2,x,1,UPPER(MID(A2,x,1))))

海角浪人

=LEFT(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1)-1)&UPPER(MID(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1),1))&MID(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1)+1,999)
超级火车，三键

亿嘉

=LEFT(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1)-1)&UPPER(MID(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1),1))&MID(A18,SMALL(IF((MID(A18,ROW($A$1:$A$50),1)>="a")*(MID(A18,ROW($A$1:$A$50),1)<="z")+(MID(A18,ROW($A$1:$A$50),1)>="A")*(MID(A18,ROW($A$1:$A$50),1)<="Z"),ROW($A$1:$A$50),999),1)+1,999)
超级火车，三键