选择性去除空格

Aotenjo

B列市希望的结果，文字间的空格，文字和数字间的空格去除，数字和数字间的空格保留。没有需要去除的则原样，文字包括英文等。

表格.rar (6.45 KB, 下载次数: 28)

2023-3-19 09:35 上传

点击文件名下载附件

sandays

=SUBSTITUTE(SUBSTITUTE(REDUCE(A1,TOCOL(SEQUENCE(10,,0)&" "&SEQUENCE(,10,0)),LAMBDA(x,y,SUBSTITUTE(x,y,SUBSTITUTE(y," ","@"))))," ",),"@"," ")

Aotenjo

sandays 发表于 2023-3-19 09:50
=SUBSTITUTE(SUBSTITUTE(REDUCE(A1,TOCOL(SEQUENCE(10,,0)&" "&SEQUENCE(,10,0)),LAMBDA(x,y,SUBSTITUTE(x, ...

谢谢，2021好像不行

祝洪忠-

Aotenjo 发表于 2023-3-19 10:01
谢谢，2021好像不行

=SUBSTITUTE(SUBSTITUTE(REPLACE(A1,TEXT(MAX(IFERROR(FIND(COLUMN(A:J)-1&" "&ROW($1:$10)-1,A1),)),"0;;999")+1,1,"@")," ",),"@"," ")

试试看 可能有局限性。

我走我流

=LEFT(TRIM(TRIM(A3)))&CONCAT(IF(ISNUMBER(-MID(A3,ROW($1:$98),1)),MID(A3,ROW($2:$99),1),CLEAN(TRIM(MID(A3,ROW($2:$99),1)))))

Aotenjo

祝洪忠- 发表于 2023-3-19 10:23
=SUBSTITUTE(SUBSTITUTE(REPLACE(A1,TEXT(MAX(IFERROR(FIND(COLUMN(A:J)-1&" "&ROW($1:$10)-1,A1),)),"0; ...

暂时没有发现局限性在哪里

我的城市你来过

=IF(ISNUMBER(MID(A1,MAX(IFERROR(UNIQUE(SEARCH(" ",A1,ROW($A$1:$A$33)),,),0))-1,1)*1),SUBSTITUTE(A1," ","",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-1),SUBSTITUTE(A1," ",""))

jisijie630

=CONCAT(MID(A1,IF(IFNA(MATCH(ROW($1:$99),FIND(ROW($1:$10)-1&" ",A1)+1,),)+(MID(A1,ROW($1:$99),1)<>" "),ROW($1:$99),99),1))

准提部林

數組//
=SUBSTITUTE(SUBSTITUTE(REPLACE(A1,MATCH(,0/("0/"&SUBSTITUTE(MID(A1&"1 1",ROW($1:$39),3)," ","/")),)+1,1,"|")," ",),"|"," ")

數字中間空格...限一組

Aotenjo

各位前辈，如果空格不单是" ",而是大致包括UNICHAR(160)    UNICHAR(32)   UNICHAR(12288)这三类，又当如何？