进击的乔巴 发表于 2021-12-15 11:05:00

如果删除最后一个逗号

请问大佬，如何一次性删除最后一个逗号

華誠车业 发表于 2022-1-10 14:00:17

=LEFT(A1,LEN(A1)-(RIGHT(A1)=","))

优居邻里超市 发表于 2022-1-11 11:38:17

=SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",")

神游斗士 发表于 2022-1-17 09:11:58

=REPLACE(A1,MAX(IFERROR(FIND(",",A1,ROW($1:$200)),"")),1,"")三键结束下拉

布艺达人郝素芝 发表于 2022-1-24 04:43:36

=LEFT(A1,LEN(A1)-(RIGHT(A1)=","))

开阳天成科技 发表于 2022-1-27 14:40:32

=LEFT(A1,LEN(A1)-(RIGHT(A1)=","))
下面适用于最后有N个逗号（前面的连续逗号小于99个）：
=LEFT(A1,FIND(REPT(",",99),A1&REPT(",",99))-1)

趁年华未老 发表于 2022-3-4 18:11:43

B1=REPLACE(A1,LOOKUP(1,0/(MID($A1,ROW($1:$100),1)=","),ROW($1:$100)),1,"")

心如玉 发表于 2022-3-7 08:16:43

=LEFT(B2,LOOKUP(1,-MID(B2,ROW($1:99),1),ROW($1:99)))

梦真 发表于 2022-3-25 04:21:58

=SUBSTITUTE(A1&"A",",A","")
页: [1]
查看完整版本: 如果删除最后一个逗号