Challenge No. 456: Extract special characters from given strings.
Solved using: R.
MID
Extracts a substring from a text string at a given position in Excel.
Identify Anti-Perfect Numbers
Challenge No. 455: Anti perfect number is that number where number is equal to sum of reverse of its perfect divisors’ digits.
Solved using: Python in Excel.
Find Penholodigital Squares
Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.
Generate Look-and-Say Sequence
Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.
Find Birds in Grid Rows
Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
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.
Split Data by Capital Letters
Challenge No. 190: Split the data into columns.
Solved using: R.
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.
Encrypt with Bifid Cipher Method
Challenge No. 432: Bifid Cipher
Suppose we want to encrypt the message “BATTLE”.
Solved using: Python in Excel.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.