Force Text

Say that you set up a spreadsheet for general use.  You expect the user to type text into certain cells, which you then use in formulas.  But they leave some cells blank.  If your text formulas refer to those cells, they read as zero, which messes up your text.  Use =T(cell) to return an empty…