Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.
LEN
Returns the length of a text string in Excel.
Remove One Letter Palindrome
Challenge No. 699: Only one alphabet can be removed from Words list and it should become a palindrome.
Solved using: Python.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
Grid Lookup By Pattern
Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
Even-Odd Reversed Squares
Challenge No. 678: Find first 50 numbers (at least 2 digits) where
1.
Solved using: Python.
First Ten Tech Numbers
Challenge No. 669: Tech Number – A number is a tech number if it has even number of digits and square of sum of first half and last half is equal to number itself.
Solved using: R.
Bi And Trimorphic Numbers
Challenge No. 665: Bi & Trimorphic Numbers – List numbers (n<100000) if n^3 and n^2 both end with n. Solved using: Python.
Largest Alternating Digit Substring
Challenge No. 657: Find the largest substring number which has alternating odd/even or even/odd digits.
Solved using: R.
Insert Dashes for Nonconsecutives
Challenge No. 637: Given alphanumeric strings, insert a dash if two characters are not consecutive in increasing order.
Solved using: Python in Excel.
Encrypt Words with Random Characters
Challenge No. 633: Encrypt the given words with following rules
1.
Solved using: Python.