Tag: example in excel

Mar162020 by excelhelp13No Comments

RIGHT Function In Excel

FORMULAS, Text

Excel RIGHT function extracts number of characters from the right side to a given cell reference. For example, =RIGHT("Game",3) gives"ame". Example given below in image and video. FORMULA: =RIGHT(B2,3)

Mar162020 by excelhelp132 Comments

LEFT Function In Excel

FORMULAS, Text

LEFT function is used to extract the specific number of letter or a word from a particular cell. It has only two parameter.First cell reference and second number of character. Left function extract from left starting position. For example "Excel help is a great website" and now if someone need to extract only Excel or Excel help then Left function is the best choice to use it. Example shown below in image and video FORMULA; =LEFT(A2,5)