Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
LOWER
Converts text to lowercase in Excel.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
List all Palindromic phrases
Challenge No. 307: List all Palindromic phrases.
Solved using: Python in Excel.
Words in Alphabetical Order
Challenge No. 293: Provide a formula to list all words from A2:A10 where English alphabets appear in alphabetical order.
Solved using: Python in Excel.
Classify Sentence Text Case
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.
Decrypt Polybius Cipher Grid
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Find Missing Alphabets
Challenge No. 172: Find the missing English Alphabets from First Ladies column.
Solved using: Power Query.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).