Challenge No. 128: Insert a space whenever there is a transition from alphabet to number OR number to alphabet in the strings.
Solved using: SQL.
ISNUMBER
Checks if a value is numeric in Excel.
Data Cleaning! Part 1
Challenge No. 98: In the Question table, historical sales values are provided in a single cell, including the Date, Product Name, and Quantity, but in a disorganized order.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Contains, Text.Split), Python, Python in Excel, and R.
List Candidates Matching Skills
Challenge No. 43: A1:C9: List of candidates with their primary and secondary skills.
Solved using: DAX.
Text After Last Number
Challenge No. 15: Find the text of string following the last numeric digit in a string.
Solved using: Python in Excel.
Separate Alphabets and Numbers
Challenge No. 2: (Excel formulas also welcome)
Extract all alphabets in one column and numbers in another column.
Solved using: Python in Excel.