Format TEXT with Formulas The next lesson demonstrates the TEXT functions. Each example creates a Cell Reference, and uses Arguments to create the formulas.   The TEXT functions include: CONCATENATE (combining fields) UPPER/LOWER SUBSTITUTE   1. Before You Begin: You can continue with the spreadsheet we have been working on or open the sample file if you wish: Counting Chickens 2013.xlsx   There should be a spreadsheet called Original Data for TEXT Formulas. Keep going, please... File->Open