请教截取字符的问题

623261 · 发表于 2023-6-21 17:15

请教各位大神一个问题：
6月21请教.png

w4275 · 发表于 2023-6-21 17:20

复制代码

qwer401245 · 发表于 2023-6-21 17:22

=TRIM(MID(SUBSTITUTE(MID($B3,13,99),"\",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))

qwer401245 · 发表于 2023-6-21 17:23

=TRIM(MID(SUBSTITUTE(MID($B3,13,99),"\",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))

623261 · 发表于 2023-6-21 17:40

qwer401245 发表于 2023-6-21 17:22
=TRIM(MID(SUBSTITUTE(MID($B3,13,99),"\",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))

谢谢大哥，太强了。

quqiyuan · 发表于 2023-6-21 18:24

=INDEX(TEXTSPLIT($B3,"\"),COLUMN(C1))

静听溪流 · 发表于 2023-6-21 20:29

=FILTERXML("<a><b>"&SUBSTITUTE($B3,"\","</b><b>")&"</b></a>","//b["&COLUMN(C1)&"]")

renzidong · 发表于 2023-6-23 12:45

=INDEX(TEXTSPLIT(B11,"\"),{2,3,4})
=TEXTBEFORE(TEXTAFTER(B7,"\",{2,3,4}),"\",,,,TEXTAFTER(B7,"\",4))

橒♂蝣 · 发表于 2023-6-23 18:15

=TEXT({1,-1,0},SUBSTITUTE(MID($B3,13,99),"\",";"))

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

[求助] 请教截取字符的问题