This even works correctly if another cell calculates the length of this cell, like: =LEN(A1). Excel uses the length without the apostrophe.
This trick is also useful if you are in the middle of writing a formula, but you want to do something else for a moment - just press HOME and add the apostrophe, go do what you needed to do. When you come back you can continue to work on the formula from the same point.
There is no need to escape other characters like spaces, arithmetic operation signs (+ or -), etc.
SummaryThis might seem like a simple tip but it is amazing how many people who use Excel happily for years then get caught out by this. If you do ever find a need to escape something, then try the apostrophe trick. It should work in all cases.
About the authorYoav Ezer co-authors the technology and productivity blog Codswallop. He is also the CEO of a company that produces PDF to XLS conversion software.
For more Excel tips from Yoav, join him on Facebook or Twitter