Challenge No. 261: Single digit prime numbers are 2, 3, 5 & 7.
Solved using: Excel VBA.
MID
Extracts a substring from a text string at a given position in Excel.
Replace Repeated Letters
Challenge No. 259: If an alphabet appears more than once, replace is with “)” otherwise replace it with “(“.
Solved using: Excel VBA.
Decrypt Route Cipher
Challenge No. 258: Route Cipher Decryption – This time you would need to decrypt the given Encrypted text.
Solved using: Excel VBA.
Extract Vowels with Positions
Challenge No. 256: Extract the vowels and their positions within the string.
Solved using: Excel VBA.
Find All Happy Numbers
Challenge No. 255: List all the Happy numbers.
Solved using: Excel VBA.
Column Splitting! Part 3
Challenge No. 156: If the IDs contain an even number of characters, split them into two columns at the midpoint.
Solved using:Excel (HSTACK, IF, IFNA), Google Sheets, Power Query (List.Transform, Text.End, Text.Start), Python, Python in Excel, and R.
Strings With Asterisks Between Letters
Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.
Recover Missing Cipher Keys
Challenge No. 253: NOTE – Order in answer is not important.
Solved using: Power Query (Text.Combine).
Convert Numbers to Expanded Form
Challenge No. 252: Write the numbers in expanded form.
Solved using: Python in Excel.
Digit Rearranged Multiplication Match
Challenge No. 251: Find those numbers which when multiplied by 2 to number of digits in that number generates the same digits in any other order.
Solved using: Power Query.