求高手帮助提取其中的数字，谢谢

117778107 · 发表于 2024-3-5 17:41

求高手帮助提取其中的数字，谢谢！

limonet · 发表于 2024-3-5 17:53

新函数：=IF(ISNUMBER(FIND("×",C7)),TEXTSPLIT(MID(C7,2,FIND(" ",C7)-2),"×"),"")

yao_ashuai · 发表于 2024-3-5 17:53

textbefore和textafter合用

海马爸爸 · 发表于 2024-3-5 17:57

D7=IFERROR(MID(C7,FIND("D",C7,1)+1,FIND("×",C7,1)-FIND("D",C7,1)-1),"")
E7=IFERROR(MID(C7,FIND("×",C7,1)+1,FIND(" ",C7,1)-FIND("×",C7,1)-1),"")
原始算法一种

limonet · 发表于 2024-3-5 18:00

普通公式右拉下接==IF(ISNUMBER(FIND("×",$C7)),TRIM(MID(SUBSTITUTE(MID($C7,2,FIND(" ",$C7)-2),"×",REPT(" ",99)),1+(COLUMN(A1)-1)*99,99)),"")

我的城市你来过 · 发表于 2024-3-5 18:13

=TOROW(TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(C7,"×",REPT(" ",66)),"D","")," ")*1,3)

miaojohn45 · 发表于 2024-3-5 18:18

=IFERROR(TEXTSPLIT(TEXTBEFORE(TEXTAFTER(C4,"D")," "),"×"),"")

复制代码

朝露孤烟 · 发表于 2024-3-5 20:31

本帖最后由朝露孤烟于 2024-3-5 20:57 编辑

=TEXT({1,-1}%,IF(LEFT(C4,1)="D",RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C4,"地",""),"上",""),"下",""),"×",";"),LEN(C4)-3),""))有点投机。
也可以是：=TEXT({1,-1}%,SUBSTITUTE(IF(ISNUMBER(FIND("D",$C7)),MID($C7,2,FIND(" ",$C7)),""),"×",";"))，数组公式。

qydn · 发表于 2024-3-5 21:00

试试这个试试这个

mykitami · 发表于 2024-3-5 21:30

=IF(LEFT(C7)="D",TAKE(TEXTSPLIT(C7,{"D","×"," "},,1),,2),"")

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

[已解决] 求高手帮助提取其中的数字，谢谢

评分