how to check function result in EXCEL

If there are two or more function in one formula, then you can check the outcome of one function using F9

For example: select substitute(“excelhome”,”e”,) and press F9, then it will show “xclhom” which is the outcome of the substitute function. if you select A2, then it will show 3 which is the outcome of the whole formula.



excel function: substitute

How to get how many E in the word EXCELHOME?


Function: Substitute–replaces existing text with new text in a text string

If leave new text blank, then it means delete the old text. For example, substitute(“excelhome”, “e”,) means delete all the “e” in the text of excelhome.