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)
Superb
Thanks you for your valuable comment.