Wednesday, November 27

Tag: excel with examples

LEFT Function In Excel

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)