如果删除最后一个逗号

进击的乔巴

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

0000.rar (7.4 KB, 下载次数: 87)

2021-12-15 11:05 上传

点击文件名下载附件
0000.rar

華誠车业

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

优居邻里超市

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

神游斗士

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

布艺达人郝素芝

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

开阳天成科技

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

趁年华未老

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

心如玉

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

梦真

=SUBSTITUTE(A1&"A",",A","")