The Right Formula

Definition

The right function works the same as the left function. The only difference is that this will give you the text from the right

Example

Let’s use the same examples

1. We only need the word “eyes”
2. We only need the word “easy”
3. Here we also need the division number, so we can use right instead of mid, because the number is at the most right of the text
4. We also need the centre number

The only difference is that the words we need are always at the end of the text.

The formula function bar

Things you can do with the right formula

• Extract data from the right of your cells data..contact us for more info

<-----Back to index

Next topic----->