本帖最后由 cutecpu 于 2019-11-12 07:20 编辑
以下公式,總價 & 面積 都只抓第一筆
B2 陣列公式:
=VLOOKUP(0,
TEXT(
ISERR(--MID("$$"&SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"万"," "),ROW($1:$99),1))*
ISERR(--MID("$"&SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"万"," "),ROW($1:$99),1))*
(--MID(SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"万"," "),ROW($1:$99),9)),
"[<1] ;0"
)*{0,1},2,)
:8 個空白
C2 陣列公式:
=VLOOKUP(0,
TEXT(
ISERR(--MID("$$"&SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"方"," "),ROW($1:$99),1))*
ISERR(--MID("$"&SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"方"," "),ROW($1:$99),1))*
(--MID(SUBSTITUTE(SUBSTITUTE(A2," ","$$"),"方"," "),ROW($1:$99),6)),
"[<1] ;0"
)*{0,1},2,)
:5 個空白
※陣列公式,請記得按Ctrl+Shift+Enter
※如果有解決您的問題,再請將帖子設為[已解決]
祝順心,南無阿彌陀佛!
|