Table of Contents Issue Often we face the issue where even after pressing “Enter”, the formula is visible instead of the results. Solution Press Ctrl ~ to switch back to normal mode. Reason This happens due to the formula view being enabled by mistake at times by pressing Ctrl ~
Table of Contents Example We have a bank statement containing the following transactions. Output Required We want to extract the names between the first delimiter and the last delimiter. Steps Select the column from which the data has to be extracted. In our example, we have to extract data from Particulars column. Goto Data tab…
Table of Contents In this article, we will learn how to set the formula calculation to automatic in Excel. Steps Go to the formula tab Click on the arrow near Calculation options Click on the Automatic option By enabling the automatic calculation option, all the formulas will be updated for any changes done in the…
Table of Contents Example We have to derive number of months between any two dates available in the data. Formula Using the formula In a new column, type the following =DATEDIF(A2,B2,”M”) Using the above formula, we will get difference in number of months. Notes:1. DATEDIF formula will not appear in the by default list functions available…