Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
MID
Extracts a substring from a text string at a given position in Excel.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Swap first and last letters unless vowels
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
Find texts that are ATBASH Palindromes
Challenge No. 314: ATBASH Palindrome – In ATBASH cipher, we replace a with z, b with y, c with x.
Solved using: Python in Excel.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.
List all Sumproduct numbers
Challenge No. 312: List all Sumproduct numbers from column A.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.