The Left Formula

Definition

The left is almost the same as the mid function as explained in 15. The only difference is that it will start from the start of the text, and give you the amount of characters you specify.

Example

Let’s use the same data as in an example

1. We only need the word “the”
2. We only need the word “excel”
3. We only need the word “division”
4. We only need the word “centre”

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

The formula function bar

Things you can do with the left formula

• Extract certainn iformation out of your data...contact us for more info
• Clean up your data if people spelled things incorrectly...contact us for more info

<-----Back to index

Next topic----->