Excel Magic Trick 1220


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

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply