Let's see what other options we have on the example of a shortlist of villains I like the most. But since it capitalizes every word in a cell and lowers other letters, sometimes it can't be a cure-all. In one of our previous articles we discussed how PROPER function can save the day. Whenever you have lists of names, products, tasks, or anything else, you will for sure have some of them (if not all) written only in small or capital letters. I believe when it comes to text in Excel, one of the most commonly required tasks is to capitalize first letters in the cells. How can we change the case of the first letter from lower to upper in Excel cells? Do we have to type each character manually into every cell? Not anymore! Today I will share three methods of capitalizing first letters in your table.
0 Comments
Leave a Reply. |