Challenge No. 268: Find the Decrypted words corresponding to Encrypted words .
Solved using: Excel VBA.
SUBSTITUTE
Replaces text in a string based on a specific match in Excel.
Extract From Text! Part 5
Challenge No. 162: Separate the values inside the curly braces { }, do the same for nested curly braces.
Solved using:Excel (IFNA, LAMBDA, LET), Google Sheets, Power Query (List.Transform, Table.AddColumn), Python, Python in Excel, R, and VBA.
Check Digit Occurrence Validity
Challenge No. 266: List those numbers only where odd digits appear odd number of times and even digits appear even number of times.
Solved using: Excel VBA.
Odd Even Min Max Split
Challenge No. 263: Separate out odd and even numbers and give their min and max separated by dash.
Solved using: SQL.
Strings With Asterisks Between Letters
Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.
Multiply Digits to Single Digit
Challenge No. 249: Multiply first digit with second digit, then result of this should be multiplied with 3rd digit and so on.
Solved using: Power Query.
Column Splitting! Part 2
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
Sort Numbers Leave Text
Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.
Count Consecutive 1s Only
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.