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?
How to create a string or formula containing double quotes in Excel?
Viewed 555856
13 Answers
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"
Alternatively, you can use the CHAR function:
= "Maurice " & CHAR(34) & "Rocket" & CHAR(34) & " Richard"
The following formula works on Excel as well as Numbers (on MAC) :
= "Maurice " & """" & "The Rocket" & """" & " Richard"
Use & """" & to get a single double quote surrounding your string.
Related