Challenge No. 140: List the common letters between Word1 and Word2 and sort them alphabetically.
Solved using: Power Query (List.Distinct, Table.AddColumn).
MID
Extracts a substring from a text string at a given position in Excel.
Unique Letters Per Word
Challenge No. 137: List those strings whose words contain only unique letters.
Solved using: Power Query (Table.AddColumn).
Replace Masked Characters
Challenge No. 131: The strings given in column A have some alphabets which are masked i.
Solved using: Excel VBA.
Capitalize First and Last
Challenge No. 130: Convert the first and last letters of each word to upper case.
Solved using: Power Query (List.Transform).
Sort with Custom Rules
Challenge No. 129: We had a sorting challenge recently.
Solved using: Power Query.
Add Spaces Between Types
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.
Left Strip Given Chars
Challenge No. 127: Remove LSTRIP Chars from Input String from left side.
Solved using: Python in Excel.
Convert Strings to Morse
Challenge No. 125: Convert given strings into Morse codes.
Solved using: SQL.
Reconciliation!
Challenge No. 110: After reconciling the company’s bank transactions with the records in the financial department, discrepancies were found between 5 rows of bank transactions and 7 rows of financial records.
Solved using: Excel.
Find Disarium Numbers
Challenge No. 124: List the Disarium numbers from column A.
Solved using: Python in Excel.