Did you know that there is a function you can use in Excel that will capitalize the first word in a cell? Neither did I until recently. That’s the beauty of these programs, you can keep learning as you go along! Nobody knows it all and I don’t know about you, but I am always looking for ways to save time and keystrokes. I like to streamline things!
The name of this function is the PROPER function.
The Syntax is: =PROPER (text).
The (text) would be the text you would want every first letter capitalized. It could be a cell reference or you can input the text direction in the function as long as you surround it with double quotation marks (i.e., “my text”).
Now, if you put the function in B1 and reference cell A1 for the text argument it looks like this:
Tap Enter and you will see your result.
For this example, I only used one cell, but if you have a large amount of data and you need the first letter of every cell capitalized, this could save you a lot of time.
You would just enter the function for the first cell and then copy that function down by double-clicking the quick-fill handle located at the bottom right of any cell that you select.
Just another little trick to tuck away in your arsenal to save you time and keystrokes!