Here we explain how to use double quotes in an Excel formula. We provide two examples on how to achieve this by escaping the quote character and by using the CHAR function.
How To Use Double Quotes in an Excel Formula
Let’s use a quick example where we want to output: Ricky “The Hitman” Hatton
The common mistake that people usually make is to write the Excel formula like so:
="Ricky "The Hitman" Hatton"Which I’m sure you already know will throw an error stating that “there is a problem with this formula”!
This is because in VB code/Excel formulas, we must escape quotes with…..another quote! Like so…
="Ricky ""The Hitman"" Hatton"And we can also use the CHAR function to return a specific character – in our case, we want to return character 34 of the Ascii table which is a quote!
="Ricky " & CHAR(34) & "The Hitman" & CHAR(34) & " Hatton"It’s as easy as that!
