Function: LEFT / RIGHT & LEN

Time to learn: 15 minutes

This is a text function that gets you specific parts of a text sentence.

Here’s an example:

=LEFT(A1,3)

Function LEFT

Like all formulas, begin with a ‘=’ and that ‘(‘ and ‘)’ would frame the contents. So counting from the LEFT, we get the first 3 letters.

Here’s an example of the RIGHT function:

=RIGHT(A2,5)

Function RIGHT

So, like the LEFT function, we count from the RIGHT and get the first 5 letters.

LEN

The LEN function counts the number of letters there are in a cell. LEN is short for length.

Here’s an example:

=LEN(A1)

Function LEN

We get 4 from counting the number of letters in ‘Here’.

Here’s something extra someone taught me:

=LEFT(A1,LEN(A1)-9)

Function LEN 2

This is a little more complex, but does something interesting. It takes every letter of cell A1 EXCEPT the last 9 items, which in this case is ‘sentence.’.  Yup, inclusive of the period.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s