# Excel Right Left and Mid Functions

Excel Right, Left and Mid functions return number of characters from selected text. These formulas can be used to get a pattern of characters from string. These formulas have same syntax in Excel 2003, 2010, 2007 and 2013. Lets start with Right Function:

## Excel Right Function

Excel Right function returns specific number of characters of selected text from right side.

### Syntax And Examples:

=RIGHT(“Text”, Count of characters to be returned)

 A 1 ExcelBee.com 2 3 =RIGHT(A1,3)

Result in A3: com

In the above example, formula in A3 has returned 3 characters from text in A1 from right side.

## Excel Left Function

Excel Left function returns specific number of characters of selected text from left side.

### Syntax And Examples:

=LEFT(“Text”, Count of characters to be returned)

 A 1 ExcelBee.com 2 3 =LEFT(A1,3)

Result in A3: Exc

In the above example, Left formula in A3 has returned 3 characters from string in A1 from left side.

## Excel Mid Function

Excel Mid function returns numbers of characters from middle of a text, starting from the specified character in formula.

### Syntax And Examples:

=Mid(“Text”, Starting position, Count of characters to be returned)

 A 1 ExcelBee.com 2 3 =MID(A1,6,3)

Result in A3: Bee

In the above example, formula in A3 has returned 3 characters starting from character number 6 from left side.

Extra Tips:

• Number of character to be returned in all three functions must be greater than or equal to zero.
• If number of character to be returned is left blank then only one character will be returned in Right and Left function and zero character in Mid function.
• If number of character to be returned is greater than the length of the text then formula will return whole text only.