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: