Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
MID
Extracts a substring from a text string at a given position in Excel.
Reverse Long Words
Challenge No. 161: If a word in sentence has length > Number, then reverse that word.
Solved using: Power Query (Text.Combine).
Alphabet Prime Mapping
Challenge No. 160: Generate first 26 prime numbers starting with 2 till 101 (101 is 26th prime number).
Solved using: Python in Excel.
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
Convert Roman to Decimal
Challenge No. 154: Convert from Roman to Decimal.
Solved using: Python in Excel.
Check Narcissistic Numbers
Challenge No. 147: A Narcissistic number is that number which is the sum of nth powers of its digits where n is the length of the number.
Solved using: Python in Excel.
List All Pangram Sentences
Challenge No. 146: A Pangram (also known as Holoalphabetic) sentence is that which contains all 26 letters of English alphabets at least once.
Solved using: Power Query (Table.SelectRows).
Right Strip Given Chars
Challenge No. 145: Remove RSTRIP Chars from Input String from right side.
Solved using: SQL.
List Harshad Numbers
Challenge No. 143: List the numbers which are Harshad number (also known as Niven number or Multidigital number).
Solved using: Python in Excel.
Next Palindrome Number
Challenge No. 141: Palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.