Challenge No. 270: Classify the sentences as per case
All Lowercase – All letters in lowercase
All Caps – All letters in uppercase
Start Case – First letters of all words in uppercase
Sentence Case – Only first letter of first word in uppercase
Mixed Case – Not following any of the rules above.
Solved using: Python in Excel.
EXACT
Case-Sensitive Revenue Lookup
Challenge No. 9: Provide the Excel formula to get Revenue in cell E3 for a company given in cell E2.
Solved using: Python in Excel.
Extract All-Caps Words
Challenge No. 4: Provide a formula to Extract the Words which are all capitals (upper case).
Solved using: Python in Excel.
