Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
CODE
Toggle Alphabet Case
Challenge No. 36: Provide a formula to reverse the case of English alphabets.
Solved using: Power Query.
Find Nth Two Against Letters
Challenge No. 28: Considering only alphabets in column A2:A20, find the alphabet corresponding to 5th 2 in column B.
Solved using: Power Query (Table.SelectRows).
Apply Caesar Cipher with Shift
Challenge No. 26: Caesar’s Cipher – This is second challenge on Caesar’s cipher.
Solved using: Power Query.
Count Letters and Digits
Challenge No. 7: Provide a formula to count the number of English alphabets and numeric digits in every cell.
Solved using: Python in Excel.