Formulas



  • Cell formula to display content, position and formatting of cell Sometimes we have many questions in mind like :How to know the cell protection status - Locked or Unlocked ?How to know the width of the cell ?How to know alignment ...
    Posted Jun 11, 2011, 10:51 AM by Ayush Jain
  • Extract email address from sentence in cell Recently I wanted to extract email address from the sentence given in the cell. I got the below formula perfectly working to get this done.EXAMPLE :1) Hello, abc@abc ...
    Posted Jun 11, 2011, 10:52 AM by Ayush Jain
  • Display Feet and Inches as 5' 8 1/2" When converting metric distances to English units of feet or inches, you'll end up with a decimal value. But, you may want to display the value as feet and ...
    Posted Mar 26, 2011, 7:06 AM by Ayush Jain
  • Hidden text in Formula By using N() function you can enter hidden text in the formula. It is helpful when you want to display any information along with formula in single Cell.Example : =2018 ...
    Posted Jan 30, 2011, 12:59 AM by Ayush Jain
  • Extract % from the Securities or any Text In finance & banking transactions, The interest rate is used in the name of many securities & transactions...If you have this data in excel sheet , then you can filter out the ...
    Posted Jan 29, 2011, 11:00 PM by Ayush Jain
Showing posts 1 - 5 of 7. View more »

Subpages (1): Formulas
Comments