Extracts a specified number of characters from the end of a text string in Excel.
Challenge No. 348: Pig Latin Cipher – A new encrypted word is created with 3 components –
Component 1 – String having all alphabets from first vowel occurrence till end of the word
Component 2 – String having all alphabets before first vowel occurrence
Component 3 – String “ay”
Anything other than the English alphabet will be left as it is.
Solved using: R.
Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
Challenge No. 294: List Tautonym words.
Solved using: Python in Excel.
Challenge No. 166: In the provided table, the Date Time values correspond to different time zones (specified in the column GMT From).
Solved using:Excel (BYROW, HSTACK, LAMBDA), Google Sheets, Power Query (Text.End), Python, Python in Excel, and R.
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.
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
