string excel空字符串公式
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3230005/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
excel empty string formula
提问by sergiol
On Excel why putting a formula with the contents
在 Excel 上为什么要放置带有内容的公式
=""
sometimes make the replacement for an empty string and sometimes it places literally that text in the cell.
有时替换一个空字符串，有时它会将文本字面放在单元格中。
Note: every cell of the worksheet is in the text format.
注意：工作表的每个单元格都是文本格式。
回答by Michael
It depends on the order in which you format the cell as text.
这取决于您将单元格格式化为文本的顺序。
If the cell is not formatted as text, your formula will read ="" and the cell will be blank.
如果单元格未格式化为文本，您的公式将显示为 =""，并且单元格将为空白。
If the cell is formatted as text, your formula will read ="" and the cell will read =""
如果单元格格式为文本，您的公式将显示为 =""，单元格将显示为 =""
If you had the cell NOT formatted as text (number or general), entered ="" and THEN formatted the cell as text, your formula will read ="" and the cell will be blank.
如果您的单元格没有格式化为文本（数字或常规），输入 ="" 然后将单元格格式化为文本，您的公式将显示为 ="" 并且单元格将为空白。
