Get Schooled at New Horizons

Info and insights from New Horizons Computer Learning Centers. 22 locations to serve you.
Start exploring

Excel text tricks: Here’s how to change case easily (Excel 2016)

You rarely use Excel for its text editing features—Excel exists to work with numbers and data. But when your spreadsheet data needs revamping, you don’t necessarily need to copy everything into Word. For example, Excel provides formulas for quickly changing the case of text. The UPPER, LOWER, and PROPER functions convert your text to all caps, lowercase, or proper case, respectively. The syntax is straightforward, too. Say your list of important contacts is in full caps, and you want the proper case (the first letter of each word capitalized). If the first name you need to convert is in cell B3, type =PROPER(B3) and press [Ctrl][Enter]. Select and drag the small black square in the lower-right corner of the cell containing your formula to instantly copy the formula for each item on your list.


Leave a Reply