Excel Magic Trick 1220: How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP

About this tutorial:

Video duration: 5:46
Download File:
Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into each cell:
1. (00:10) Problem Setup
2. (01:00) IF Function Example
3. (01:50) How to use An Extra Double Quote in Text Formula to put a Double Quote into a Text Formula.
4. (02:45) VLOOKUP solution

Double Quotes Don’t Work in Text Formula.
How to put Double Quotes in Text Formula: IF and Two Extra Double Quotes or VLOOKUP

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *