Challenge No. 1: Extract the numeric digits from the given strings in a column and sum the digits for those extracted strings in another column.
Solved using: Power Query (Table.AddColumn).
MID
Extracts a substring from a text string at a given position in Excel.
Oeis Sequence
Challenge No. 53: The On-Line Encyclopedia of Integer Sequences presents several number sequences based on specific rules.
Solved using:Excel (FILTER, LAMBDA, LEFT), Power Query (List.Transform), Python, and R.
Text Split!
Challenge No. 45: The “Question” table contains product IDs of varying lengths.
Solved using:Excel (LAMBDA, LET, MID), Power Query (List.Transform, List.Zip, Table.AddColumn), Python, R, and VBA.
Row Combinations
Challenge No. 3: Extract all possible combinations of ID and result in the right-side table.
Solved using:Excel (BYROW, COUNTA, DROP), Power Query (List.Transform), Python, and Python in Excel.