Uppercase, Lowercase, and The Proper Capitalization.
=upper() The upper function puts your text in “all caps”. I.E. “THIS IS AN EXAMPLE OF UPPER.”
=lower() The lower function puts your text into all lower case letters. I.E. “this is an example of lower.”
=proper() The proper function capitalizes the first letter of ever word in the cell value. I.E. “This Is An Example Of Proper.”
This video goes into each function.
Did you know there are only a handful of tools that differentiate an excel expert from an intermediate user?
Yesterday my good friend said, “Anytime someone says they are an excel expert I know they don’t know anything.” I know where he is coming from. I have the same bias. As I learn a new tool in Excel I realize how much more there is to learn. But you don’t have to know how to use every tool to be an expert. When it comes to Excel, it really is possible to become an expert in a short amount of time because there are only about a half dozen areas where people get stuck, bottlenecks. Manipulating data is one area where cut, copy, and paste is just a portion. If you would like to access my (Rho Lall’s) full mind-map, Become An Excel Expert, it covers all five areas. Just follow this link to my become an excel expert mind-map.