## Excel Text functions: left, right, T

#### Excel Function LEFT

The LEFT() function is used to retrieve the left most portion of the specified string.

This function takes two parameters: text and number of characters.

The second parameter specifies the number of characters to be returned by the function.

 Number LEFT() FORMULA BIRD fly high BIRD =LEFT(L4,4) Man and Woman Man an =LEFT(L5,6) I am here I am =LEFT(L6,5) This is me T =LEFT(L7) Animals in zoo. An =LEFT(L8,2)

#### Excel Function RIGHT

The RIGHT() function is used to retrieve the right most portion of the specified string.

This function takes two parameters: text and number of characters.

The second parameter specifies the number of characters to be returned by the function.

 Number RIGHT() FORMULA BIRD fly high high =RIGHT(L16,4) Man and Woman Woman =RIGHT(L17,6) I am here here =RIGHT(L18,5) This is me e =RIGHT(L19) Animals in zoo. o. =RIGHT(L20,2)

#### Excel Function T

The T() function is used to check if the supplied value is a text.

If the given string is text, then the function returns the text itself, else, it returns an empty string.

 Number T() FORMULA BIRD fly high BIRD fly high =T(L28) 23 =T(L29) 0.12 =T(L30) 12345t 12345t =T(L31) 11/12/2014 =T(L32)