选择公式所在的列,点击“数据”中的“分列“,在弹出的对话框中直接点击”完成“,这样所选列中原来显示公式的单元格,就显示公式计算结果了。
工具/原料:
win10
Microsoft Excel 2019
1、在Excel单元格中输入了公式,如下图所示。
![](https://iknow-pic.cdn.bcebos.com/d4628535e5dde71138cfb966b5efce1b9d166105?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、如果公式仅显示公式本身而非计算结果,如下图所示。
![](https://iknow-pic.cdn.bcebos.com/b58f8c5494eef01f8e09e255f2fe9925bc317d05?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、此时,可以选择公式所在的列,点击“数据”中的“分列“,如下图所示。
![](https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d32c3f8e94850a304e251f5805?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的对话框中直接点击”完成“,如下图所示。
![](https://iknow-pic.cdn.bcebos.com/f9198618367adab467cce1d399d4b31c8701e406?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这样所选列中原来显示公式的单元格,就显示公式计算结果了,如下图所示。
![](https://iknow-pic.cdn.bcebos.com/a8ec8a13632762d0bc225e2fb2ec08fa513dc606?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)