72. Excel Tips - Use Inverted Commas In Excel Formula
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)
Training Video on how to Use Inverted Commas In Excel Formula: