Always make yourself better

–Read book;

–Do not LAZY: hand wash Emily’s clothes; Work out; Cook healthy lunch; Clean up the house…..

Everyday you have so many things to do. Do not lazy!!

–Practice your English and improve everyday;


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

Source: excel function: substitute


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.