How to use the number formula in excel

How to use excel formula: First select a cell to write the formula equal to the first two digits of "I am Chinese", select B6; then enter the formula "=LEFT(C4,2) in B6 "The two words "I am" will appear; finally, enter the formula "=RIGHT(C4,3)" in D6, and the three words "Chinese" will appear.

#First select a cell and prepare to write the formula equal to the first two digits of "I am Chinese", for example, select cell B6 in the picture below;

Enter the formula "=LEFT(C4,2)" in cell B6, and the words "I am" will appear;

After entering the formula "=RIGHT(C4,3)" in cell D6, the three words "Chinese" will appear.

The above is the detailed content of How to use the number formula in excel. For more information, please follow other related articles on the PHP Chinese website!