## Tips & Tricks 163 - Convert Alphabets to Numbers

If you want to convert a, b, c....z to 1, 2,3....26, the you can use following type of formula -

=CODE(UPPER(A1))-64

Sat 30
Sep 2017

If you want to convert a, b, c....z to 1, 2,3....26, the you can use following type of formula -

=CODE(UPPER(A1))-64

Tue 03
Jan 2017

Below is a possible solution to the **Challenge 57 - Another Word Challenge - Palindrome or Not**

Use the below formula -

Mon 05
Dec 2016

Below is a possible solution to **Challenge 55 - Make an Alphabetic Triangle**

Put following formula AB4 somewhere and drag to the right.

Sat 03
Dec 2016

We earlier had challenges related to Pangram, Isogram and Anagram. This time, it is about Palindrome. A Palindrome is a word / sentence that reads the same from backward also as it reads from forward. Some of the famous Palindromes are

Sat 05
Nov 2016

This time challenge before you is to write a formula which can be dragged down, left and right to make the below triangle.

Mon 10
Oct 2016

Below is a possible solution to the **Challenge 51 - Another Word Challenge - Whether Given Words are Anagram or not**

Use following formula -

=IF(AND(LEN(A1)=LEN(B1),SUMPRODUCT(--(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),

UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))=LEN(B1)-LEN(SUBSTITUTE(

UPPER(B1),UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),""))))=LEN(A1)),"Anagram","Not Anagram")

Tue 13
Sep 2016

Below is a possible solution to the challenge - **Challenge 49 – Whether a Word is Isogram or Not**

Use following formula -

=IF(SUMPRODUCT(--(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW($65:$90)),""))>1))

=1,"Not Isogram","Isogram")

Sat 10
Sep 2016

Given a word, an anagram is made by using all letters of the given word exactly once. For example, For example, my name "vijay" can be written as "jaivy", "yajvi" and so on....Some well known anagrams are

Lead - Flea

Admirer - Married

Listen - Silent

Mother in Law - Woman Hitler

Eleven Plus Two - Twelve Plus One

So, below is the challenge. Put original word in A1 and anagram in B1. You need to put a formula which gives the result "Anagram" if B1 has anagram of A1 and gives "Not Anagram" if B1 is not anagram of A1.

*The solution to the above challenge will be published after a month i.e. on 10-Oct-16.*

Tue 30
Aug 2016

Below is a possible solution to the challenge - **Challenge 48 - Whether a Sentence is Pangram or Not**

=IF(ISNUMBER(SUMPRODUCT(MATCH(ROW($65:$90),INDEX(CODE(MID(SUBSTITUTE(SUBSTITUTE(

SUBSTITUTE(UPPER(A1)," ",""),".",""),",",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(SUBSTITUTE(

SUBSTITUTE(A1," ",""),".",""),",","")))),1)),,),0))),"Pangram","Not Pangram")

Sat 13
Aug 2016

This time, continuing my effort to make challenge on English language, the challenge is on Isogram. An Isogram is that word in English which doesn't repeat any alphabet. For example: "Botany" is an Isogram but "Britain" is not as "i" repeats.

Hence, this time, you need to make a formula which returns "Isogram" if the word is Isogram othewise returns "Not Isogram"

*The solution to above challenge will be published after a month i.e. on 13-Sep-16.*