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) |