问题描述
我可以在单元格中的公式后添加多行文本. (请参阅)但是现在该单元格已变成文本单元格，当我将其用作数字单元格时，似乎无法将其用作数字单元格想要单元格的总和.我该如何使用
I can add multi-line text after a formula in a cell. (see how to append a multi-line text after a formula in Microsoft Excel?) But now that cell had been turned into a text cell and it seems I cannot use the cell as a numeric cell, when I want the cell in a summation. how can I use a cell like
=CONCATENATE(F20/20, CHARACTER(10), "*note 4)")
作为另一个单元格中数值计算的输入?
as an input of a numeric calculation in another cell?
推荐答案
最简单的解决方案是在公式中引用F20.
The simplest solution would be just to reference F20 in your formula.
但是，如果不可能的话，您可以使用LEFT()和FIND()的组合对连接进行反向工程，以将其取回以用于计算.
However, if that's not possible you can just reverse engineer your concatenate with a combination of LEFT() and FIND() to get the number back out of it to use in a calculation.
假设您的串联单元格位于A1中，并返回:
Let's say your concatenated cell is in A1, and returns:
9
(note 4)
将此公式放在另一个单元格中:
Put this formula in another cell:
=LEFT(A1,FIND(CHAR(10),A1)-1)*1
这将返回9，格式为数字.
And that will return 9, formatted as a number.
这篇关于如何将由数字和文本串联而成的单元格用作另一个单元格计算的输入?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！