Challenge No. 144: Match the Acronyms given in column C against the words given in column A.
Solved using: SQL.
LEFT
Extracts a specified number of characters from the beginning of a text string in Excel.
Top Initial Letters Count
Challenge No. 138: Find the top 5 highest occurring starting alphabets of words in US Presidents columns.
Solved using: Python in Excel.
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).
Add Large Text Numbers
Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.
Signed Binary to Decimal
Challenge No. 118: Convert binary numbers into decimal numbers.
Solved using: Python in Excel.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Presidents With B Word
Challenge No. 54: Find the list of US Presidents where any word in the name start with B.
Solved using: DAX.
Sum Tenure of US Presidents
Challenge No. 51: Provide a formula to calculate the total (sum) years of tenure of all US presidents.
Solved using: Power Query.
Same Initial Letter Names
Challenge No. 45: Provide a formula to list the names where all words start with same alphabet.
Solved using: Power Query (Table.SelectRows).
Second Words Start with C
Challenge No. 12: List the words where second word starts with C.
Solved using: Python in Excel.