How to create a string or formula containing double quotes in 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"