Extracts a substring from a text string at a given position in Excel.
Challenge No. 250: Classify the given passwords as
Invalid – If less than 8 characters
If >= 8 Characters
Weak – Contains only alphabets or only numbers or only special characters
Strong – Contains either alphabets+numbers or alphabets+special characters or numbers+special characters
Very Strong – Contains all 3 i.
Solved using: Excel VBA.
Challenge No. 249: Multiply first digit with second digit, then result of this should be multiplied with 3rd digit and so on.
Solved using: Power Query.
Challenge No. 248: Print the name of month & quarter as per position of 1.
Solved using: Power Query.
Challenge No. 247: This problem is an extension of first challenge.
Solved using: Excel VBA.
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
Challenge No. 244: List all Super-palindromes from column A.
Solved using: Python in Excel.
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Challenge No. 236: We had 3 challenges on Caesar’s Cipher (if you are unaware about Caesar’s Cipher, I will encourage you to visit previous challenge to get an idea)
This is a variation of Caesar’s Cipher.
Solved using: Power Query (List.Transform).
