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)
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:
»
- Nick's blog
- Login or register to post comments
- 52074 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago