尘心风舞 发表于 2021-12-25 09:41:15

=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)))))

谷谷 发表于 2021-12-25 12:48:17

好像不对哦~

鼓捣猫 发表于 2021-12-28 19:27:44

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

吉晋 发表于 2021-12-29 04:34:20

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

拿鱼 发表于 2022-1-1 13:06:05

=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)

阿凡哒 发表于 2022-1-2 20:26:03

=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)

尛强 发表于 2022-1-7 10:38:08

=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,)
三键输入公式

袁平 发表于 2022-1-15 13:26:57

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

海角浪人 发表于 2022-1-17 22:21:44

=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)
超级火车，三键

亿嘉 发表于 2022-1-21 06:07:47

=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)
超级火车，三键
页: 1 [2] 3 4
查看完整版本: 如何将有数字、符号、字母的单元格内容第一个字母改为大写，而其余字母大小写不变 ...