Adding inverted commas (quotation marks) to a piece of text is a little fiddly:

• Just typing =""  will return nothing in a cell
• It turns out that you need to use:  =""""  (4 inverted commas) to return " 

Here's how it looks in Excel:

In this Example, we add inverted commas to ExcelExperts.com using the following formula:

=""""&"ExcelExperts.com"&""""   (or B2 in the example)

Download sheet to practise how to Use Inverted Commas In Excel Formula in Excel

Training Video on how to Use Inverted Commas In Excel Formula: