Challenge No. 457: Extract the numbers if they are within parenthesises.
Solved using: Python in Excel.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Extract Special Characters Only
Challenge No. 456: Extract special characters from given strings.
Solved using: R.
Count Numbers from Ranges
Challenge No. 454: Today’s challenge is contributed by Sunny Baggu
Extract the total numbers in the problem strings.
Solved using: Python in Excel.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
Find Missing Pythagorean Quadruple
Challenge No. 429: A Pythagorean quadruple is a set of 4 integers a, b, c, d such that d^2 = a^2+b^2+c^2.
Solved using: Python in Excel.
Blend RGB Colors into Hex
Challenge No. 425: To blend hex color, take the average (round to 0) of respective Rs, Gs and Bs of two colors and generate the Hex color for the result.
Solved using: Python in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Normalize Table from Merged Cells
Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.