Excel Magic Trick 1220

How To Put Double Quotes In Text Formula: Extra Double Quotes Or VLOOKUP


Learn how to either use IF function and Extra Double Quotes or VLOOKUP to put the text 5’6” or 6’ into each cell:
(00:10) Problem Setup
(01:00) IF Function Example
(01:50) How to use An Extra Double Quote in Text Formula to put a Double Quote into a Text Formula.
(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


Be the first to comment

Leave a Reply