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)

 

You can find similar Excel Questions and Answer hereunder

1) Concatenate number with text but keeping in number format in Excel

2) How can I have text autocomplete based on values previously entered in Column?

3) Remove the apostrophe cell text values in Excel

4) Converting numbers stored as text to numbers via macro in Excel

5) How can I get the most frequently occurring text in a range?

6) text functions trim value lower upper concatenate

7) text functions find search len mid bahttext

8) How can I have text autocomplete by typing in a short code for the text?

9) text functions exact fixed proper rept text

10) Here an explanation about text box and how to control text boxes in Excel VBA

 

Here the previous and next chapter