3 case functions you need to know: ✍️
1. UPPER
Instead of using the caps lock key to manually type out text in uppercase format, try the UPPER function. The UPPER function automatically converts all characters in the text string to uppercase.
Instead of using the caps lock key to manually type out text in uppercase format, try the UPPER function. The UPPER function automatically converts all characters in the text string to uppercase.
2. LOWER
Have you ever been in the zone typing away, and suddenly you look up to realize caps lock was on the whole time? Instead of retyping all of the text, we can use the LOWER function. LOWER automatically converts all characters in the text string to lowercase.
Have you ever been in the zone typing away, and suddenly you look up to realize caps lock was on the whole time? Instead of retyping all of the text, we can use the LOWER function. LOWER automatically converts all characters in the text string to lowercase.
3. PROPER
Messy data? No problem. Never waste time manually formatting proper nouns again with the PROPER function. PROPER capitalizes the first letter of every word in a text string and converts all other letters to lowercase.
Messy data? No problem. Never waste time manually formatting proper nouns again with the PROPER function. PROPER capitalizes the first letter of every word in a text string and converts all other letters to lowercase.
Make sure to save this thread to avoid having to manually reformat text!
Follow me @exceldictionary for even more #Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com
Follow me @exceldictionary for even more #Excel tips and tricks.
And if you never want to forget my excel tips at your desk, check out my shortcut merch and ebooks. shop.morningbrew.com
Loading suggestions...