Let’s say you have a list of mobile nos. and you need to check how many of them are exact 10 digits. Thus, it will immediately tell you others are incorrect. Column A has the list of Mobile nos. There are 2 ways to count the mobile nos. having 10 digits. 1) Using 1 extra […]

# Text Functions

# Delete last 10 characters from all cells in Excel

*By* rushabhs
*in* Formulas, Text Functions
No Comments

Let’s say you have a text having Name of a person & his/her 10 digit mobile number in the same cell. Example – You have this text in cell A1 “Rushabh Shah 9836999999” You want to extract only the Name of the person without the mobile number and place the name in B1. Using only […]

# Change text to Upper Case

*By* rushabhs
*in* Formulas, Text Functions
No Comments

It’s quite easy to convert text to upper case in Word, but how do you do it in Excel?!Suppose your text is in cell C3 which you want in Upper Text. In Cell C4 (or anywhere where you need your text in Upper Case), write the below extremely simple formula: – =UPPER(C3) If C3 has […]

# Extracting data from right side of a string

*By* rushabhs
*in* Formulas, Text Functions
No Comments

Suppose you have a list of mobile nos, with a 0 as prefix. Now you do not want that 0 to be there, and it should be only a 10 digit mobile number.This is simple! You can use the =RIGHT formula, which extracts the required number of characters, starting from the right part of your […]