Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.
SEARCH
Finds the position of a substring in a text string (case-insensitive) in Excel.
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.
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Group Text by Keyword
Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.
Counting TextString
Challenge No. 42: Count Stalls Stocking either Apple or Kiwi
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
Second Words Start with C
Challenge No. 12: List the words where second word starts with C.
Solved using: Python in Excel.