作者: SuckCopy (noname) 2022-10-24 13:28:00
a3=FILTERXML("<x><y>"&SUBSTITUTE(A1,CHAR(10),"</y><y>")&"</y></x>","//y[23]")a4就將23改為37上面固定位置,或"//y[following::*[2]='隱藏入帳明細']xpath="//y[preceding::*[4]='訂單進帳']"
作者: SuckCopy (noname) 2022-10-26 11:34:00
REPLACE(SUBSTITUTE(LEFT(A1,FIND("號",A1)),CHAR(10),","),1,7,"")