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

问题描述

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

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

MauriceThe RocketRichard

Maurice "The Rocket" Richard

如果我使用单引号，它是trivial = Maurice'The Rocket'Richard关于双引号？

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

推荐答案

您是否尝试使用双引号进行转义？

Have you tried escaping with a double-quote?

= "Maurice ""The Rocket"" Richard"

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