Yogendra Pratap Mishra

-:Formulas that help with text:- Description Formula Puts all text characters in uppercase =UPPER(  [cell]  ) Puts the first text character of each word in uppercase and all subsequent text characters in lowercase =PROPER(  [cell]  ) Puts all text characters in lowercase =LOWER(  [cell]  ) Formulas   that are just cool:- Description Formula Combines the text in designated cells and/or any specified cells in a single cell =CONCATENATE(  [cell] ,  “text” ,  etc.  ) Compares two cells together to see if they match =EXACT(  [cell 1] ,  [cell 2]  ) Checks a cell to see if it’s blank =ISBLANK(  [cell]  ) Inserts the current date =TODAY()

-:Formulas that keep your characters in line:- Description Formula Takes only the characters the designated amount when moving from the left =LEFT(  [cell] ,  [number of characters]  ) Takes only the characters the designated amount when moving from the right =RIGHT(  [cell] ,  [number of characters]  ) Takes only the characters from the designated character moving from the left =MID(  [cell] ,  [character start number] ,  [number of characters]  ) Removes any extra spaces before or after a set of text =TRIM(  [cell]  ) Counts the number of characters in a cell =LEN(  [cell]  ) Formulas that help with text:- Description Formula Puts all text characters in uppercase =UPPER(  [cell]  ) Puts the first text character of each word in uppercase and all subsequent text characters in lowercase =PROPER(  [cell]  ) Puts all text characters in lowercase =LOWER(  [cell]  )

   -: Formulas that make math a snap :- Yogendra Pratap Mishra Description Formula Adds up all selected cells =SUM(  [range]  ) Averages all selected cells =AVERAGE(  [range]  ) Formulas that count it all up. Description Formula Counts how many cells contain numbers =COUNT(  [range]  ) Counts how many cells are not blank (including cells containing numbers and cells containing letters) =COUNTA(  [range]  )

Lyrics-Yogendra Pratap Mishra Date & Time -10/10/2018 -05:03 Tumse milkar Maine Mana. Aur Sach me ye jana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Ye dard de duniyaan. Na tu kabhi tute. Tera hai pyaar sahi. Natu kabhi tute. Kuch galat hai nahi jamaana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Tumse milkar Maine Mana. Aur Sach me ye jana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Bahut kadin hai Safar. Muskilen fhir bhi magar. Na haunsla kshute. Na hi ye man ruthe. Tere man ne ab ye jana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Tumse milkar Maine Mana. Aur Sach me ye jana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Na koi sikva Kar. Aur Kar na koi gila. Tu Kar vahi Jo man kahe. Tera hi hoga bhala. Na khuf kha is jamane se. Ye jamaana hai bhala. Ab Dil lagakar tune Mana. Pyaar hai ek hasi pyaar hai ek khusi.-2 Tumse milkar Maine Mana. Aur Sach me ye jana. Pyaar hai ek hasi pyaar hai ek khusi.-2