excel - 从单个列中复制多个值

Question

Excel 工作表在一列中有 y = 498.7x - 11.323 之类的值。我想在同一张表的不同列中复制“498.7”和“-11.323”值。我们可以这样做吗？

标签： excel

Answer 1

根据我下面的屏幕截图，您可以尝试FILTERXML()公式。

B1=

=TRIM(RIGHT(SUBSTITUTE(FILTERXML("<t><s>"&SUBSTITUTE($A1,"x","</s><s>")&"</s></t>","//s[position()=1]")," ",REPT(" ",100)),100))*1

C1=

=FILTERXML("<t><s>"&SUBSTITUTE($A1,"x","</s><s>")&"</s></t>","//s[last()]")