Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
SUBSTITUTE
Replaces text in a string based on a specific match in Excel.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Signed Number String Sum
Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
Complete Square by X Placeholder
Challenge No. 524: Fill in the digit marked as X to make the number a perfect square.
Solved using: R.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
List Palindromic Evil Numbers
Challenge No. 464: Work out the first 1000 Evil Numbers (at least 2 digits) which are Palindromic also.
Solved using: Python in Excel.
Count Numbers from Ranges
Challenge No. 454: Today’s challenge is contributed by Sunny Baggu
Extract the total numbers in the problem strings.
Solved using: Python in Excel.
Encrypt Using Columnar Cipher
Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Encrypt Using Bifid Cipher
Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
Validate IMO Check Digit
Challenge No. 414: IMO Number of a Vessel – This is a 7 digit number where last digit is check digit.
Solved using: Python in Excel.