求一个快速拆分的公式.

zxjcn · 发表于 2023-5-22 17:44

030506091216172022283033
050810111315162124243133
010206070809101419212527
030506101416212223263133
030506101415182023243233
060709101720222426293132
020405061015161921252932
010609101316192123242628
020305111214161718252729

拆分格式为2个数字中间一个逗号

03,05,06,09,12,16,17,20,22,28,30,33

w4275 · 发表于 2023-5-22 17:51

=TEXTJOIN(",",1,MID(A1,ROW($1:$12)*2-1,2))

复制代码

橒♂蝣 · 发表于 2023-5-22 17:59

=TEXTJOIN("，",1,MID(A1,SEQUENCE(,LEN(A1)/2,1,2),2))

zxjcn · 发表于 2023-5-22 21:50

w4275 发表于 2023-5-22 17:51

'030506091216172022283033
'050810111315162124243133
'010206070809101419212527
'030506101416212223263133
'030506101415182023243233
'060709101720222426293132
'020405061015161921252932
'010609101316192123242628
'020305111214161718252729

请问如果前面加个音引号. 需要改哪里?

zxjcn · 发表于 2023-5-22 21:51

橒♂蝣发表于 2023-5-22 17:59
=TEXTJOIN("，",1,MID(A1,SEQUENCE(,LEN(A1)/2,1,2),2))

'030506091216172022283033
'050810111315162124243133
'010206070809101419212527
'030506101416212223263133
'030506101415182023243233
'060709101720222426293132
'020405061015161921252932
'010609101316192123242628
'020305111214161718252729

请问如果前面加个音引号. 需要改哪里?

橒♂蝣 · 发表于 2023-5-22 21:55

zxjcn 发表于 2023-5-22 21:51
'030506091216172022283033
'050810111315162124243133
'010206070809101419212527

=TEXT(TEXTJOIN("，",1,MID(A1,SEQUENCE(,LEN(A1)/2,1,2),2)),"0")

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

[已解决] 求一个快速拆分的公式.