大神提取双引号里面的汉字用空格分开

1055443241 · 发表于 2024-4-15 22:35

大神提取双引号里面的汉字用空格分开

cnmlgb9998 · 发表于 2024-4-15 22:47

复制代码

测试无误。

mykitami · 发表于 2024-4-15 23:00

=TEXTSPLIT(A2,,VSTACK("""",SEQUENCE(10)-1,",",";","}","]",":","."),1)

boyuanoffice · 发表于 2024-4-15 23:18

复制代码

HAOQ · 发表于 2024-4-15 23:24

=TEXTJOIN(" ",,CHOOSECOLS(TEXTSPLIT(SUBSTITUTE(A2,"""",),":",","),1))

excel玉米 · 发表于 2024-4-16 04:55

Vba的正则表达式提取

我的城市你来过 · 发表于 2024-4-16 14:55

=TRIM(SUBSTITUTE(CONCAT(LET(x,MID(A2,SEQUENCE(LENB(A2)),1),IF(LENB(x)=2,x,"@"))),"@"," "))

象山海鲜 · 发表于 2024-4-16 16:02

=TEXTJOIN(" ",1,TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"""",REPT(" ",999),ROW(1:99)*2-1),"""",REPT(" ",999),ROW(1:99)*2-1),999,999)))

复制代码

朱先飞 · 发表于 2024-4-17 11:58

=TEXTJOIN(" ",,TEXTSPLIT(A2,MIDB(A2,SEQUENCE(LENB(A2)),1),,1))

铁马金戈1970 · 发表于 2024-4-18 16:05

朱先飞发表于 2024-4-17 11:58
=TEXTJOIN(" ",,TEXTSPLIT(A2,MIDB(A2,SEQUENCE(LENB(A2)),1),,1))

MIDB()最简单直接，一步到位去除双字节，LENB()改成LEN()效率就更高了

		自动登录	找回密码
密码			免费注册

[求助] 大神提取双引号里面的汉字用空格分开