分拆

ddz79101

solextrade 发表于 2024-6-28 11:21
=TRIM(MID(SUBSTITUTE(C2,"_202",REPT(" ",99)),18,99))

谢谢老师！结果正确！

ddz79101

part98 发表于 2024-6-28 11:24

谢谢老师！结果正确！

ddz79101

袁勇 发表于 2024-6-28 11:26
前缀都一样吗？

=MID(LEFT(SUBSTITUTE(C2,"_",REPT(" ",99),3),99),18,99)

谢谢老师！结果正确！

ddz79101

mykitami 发表于 2024-6-28 11:29
=TEXTBEFORE(MID(C2,18,99),"_",-1)

谢谢老师！结果正确！

ddz79101

静听溪流 发表于 2024-6-28 11:31
=TRIM(MID(SUBSTITUTE(C2,"_",REPT(" ",99),3),17,99))

谢谢老师！结果正确！

ddz79101

leepoison 发表于 2024-6-28 11:22
=TEXTBEFORE(SUBSTITUTE(TEXTAFTER(C2:C7,"dzfp_233120000001"),"_","+",2),"+")

谢谢老师！我整理显示#NAME?

ddz79101

mykitami 发表于 2024-6-28 11:29
=TEXTBEFORE(MID(C2,18,99),"_",-1)

谢谢老师！我整理显示#NAME?

博爱风雨同舟

=TEXTJOIN("_",,RIGHT(CHOOSECOLS(TRIM(MID(SUBSTITUTE(C2,"_",REPT(" ",99)),COLUMN(A:E)*100-99,99)),{2,3}),{8,10}))

静听溪流

ddz79101 发表于 2024-6-28 12:26
谢谢老师！我整理显示#NAME?

TEXTBefore\TEXTAFTER是365版本才有的函数

静听溪流

ddz79101 发表于 2024-6-28 12:25
谢谢老师！结果正确！

   不用客气