LEFT, RIGHT, MID and LEN text functions in Excel 2013

LEFT

left(text, num_chars)

As the name suggests, LEFT function extracts a part of text string from the left side of a given string. The syntax takes the input string as "text" and number of characters to be extracted as "num_chars".

RIGHT

right(text, num_chars)

RIGHT function does exactly same thing as LEFT but it extracts text from extreme right.

MID

MID(text, start_num, num_chars)

MID function is slightly more sophisticated. This function extracts string from the middle of the input text. It needs starting point count "start_num" which it considers from left side of the text and then extracts number of charters defined by "num_chars"

LEN

LEN(text)

This function returns the number of characters in a text string. The input text string can be a direct input inside "" or by giving a cell reference.