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
1ExcelBee.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
1ExcelBee.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
1ExcelBee.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.
Was this article helpful?
YesNo