如何在 Excel 公式中创建包含双引号的字符串? [英] How to create strings containing double quotes in Excel formulas?

问题描述

如何在 Excel 公式中构造以下字符串:

How can I construct the following string in an Excel formula:

莫里斯火箭"理查德

如果我使用单引号，这很简单 = "Maurice 'The Rocket' Richard" 但是双引号呢?

If I'm using single quotes, it's trivial = "Maurice 'The Rocket' Richard" but what about double quotes?

推荐答案

您是否尝试过使用额外的双引号进行转义?通过转义字符，您是在告诉 Excel 处理;字符作为文字.

Have you tried escaping with an additional double-quote? By escaping a character, you are telling Excel to treat the " character as literal text.

= "Maurice ""The Rocket"" Richard"

这篇关于如何在 Excel 公式中创建包含双引号的字符串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！