Functions 4: LEFT / RIGHT & LEN

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:


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:


Function RIGHT

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


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

Here’s an example:


Function LEN

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

Here’s something extra someone taught me:


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: Logo

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

Facebook photo

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

Connecting to %s