When working with text data, a common task is to make the data consistent by capitalizing the first letter in each cell (or to capitalize the first letter of each word in all the cells) In this tutorial, I will show you a couple of methods to capitalize the first letter in Excel cells...
These related formulas modify text in different ways:UPPER - Converts a text string into all uppercase letters. LOWER - Converts text into all lowercase letters. PROPER - Converts a word into an attempted "proper" capitalization, capitalizing proper nouns.Usage on cells:...