Another group of formulas you may find useful are ones that work with TEXT. Three come to mind. The UPPER function formats all of the data as UPPER case. The LOWER function formats the data as LOWER case. The CONCAT (CONCATENATE) formula combines cells together. For example,
Combine Text with a Formula
| A | B | C | D | |
| 1 | Last Name | First Name | COMBINED | |
| 2 | Anderson | Jackie | =CONCAT(B2,” “,A2) |
=CONCAT(B2,” “,A2)
Let’s take this formula apart. All equations start with equals. The First Name is in cell B2; the Last Name is in cell A2.
What goes in between the two cells? A space would separate the First Name from Last Name. The space, punctuation, and text that we use between the combined cells is called a Delimiter.
We can use Text2, the second row in the Function Arguments, to add that TEXT (a space). Excel puts TEXT in quotes.
It makes more sense when you try it. There is a spreadsheet you can work with if you wish. Look in the bottom right corner for the sample file. -Elizabeth
Sample Spreadsheet for Text Formulas
Look for the little paper clip icon under this post- Elizabeth
