Doesn’t it make you nuts when you receive a list of names is Excel and all of them are in caps? Or better yet, the person who gave you the data decided to mix and match them with alternating cases.
Upper() Lower() Proper()
One option is to retype the entire column in proper case. But why would you do that when Excel gives you the following functions: UPPER, LOWER & PROPER.
Simple really, enter the function and the cell reference for the string you want to transform. UPPER(cell reference here)
And you can see the results for yourself…..
Upper() Lower() Proper()
Related posts: