![]() Just like the UPPER function, you only need to provide a single argument: the text you'd like in lower case. In column E, let's convert the names to lower case using the LOWER function. For example, I can easily reverse these names and add a comma between them, instead of a space. This formula can be as flexible as you need. What if you need both first and last names in upper case? To do that, you just need to concatenate the first and the last names with a space inside the UPPER function. When I add the formula and copy it down, we'll get all first names in uppercase text. The UPPER function takes just one argument: the text you want in upper case. In column D, I'll add a formula that capitalizes the first name using the UPPER function. ![]() Column B contains last names in uppercase text, and column C contains first names with the first letter capitalized. In this worksheet, we have two columns that contain names. In this video we'll look at three functions that allow you to easily change case of text in Excel: UPPER, LOWER, and PROPER. When you're working with text in Excel, you'll frequently need to change case.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |