With a few keystrokes, you’re performing advanced calculations fast. Excel makes complex math equations easy with built-in features. Once again, your solution value appears in the cell where you entered the formula. This just tells Excel to perform the calculation on the value 100, rather than on existing cell data.Release the Ctrl button, type the closing parenthesis, and press Enter. Press and hold Ctrl and click on each cell you want to concatenate. Type =CONCATENATE ( in that cell or in the formula bar. But creating a spreadsheet fro.Select a cell where you want to enter the formula. Whether you’re managing a budget, tracking inventory, or analyzing data, spreadsheets can help you stay organized and efficient. 5.Spreadsheets are an essential tool for organizing data and tracking information. Combination of LEFT, TEXT, FIND, ROUND and LEN Functions to Remove Scientific Notations. Use of TRUNC Function to Avoid Scientific Notation and Get Numbers Without e. Insert Excel TRIM Function to Get Rid of Scientific Notation. Apply Excel INT Function to Convert Scientific Notation to Number Without e.