The Trim Formula
Difinition
The trim formula makes a text look better. For example when you have a code from your system but for some reason it has empty spaces after every code. With trim you can take out all unnecessary spaces in text
Example
Nr |
Text |
Formula |
Answer |
1 |
Income Statement |
=TRIM(B2) |
Income Statement |
2 |
April June August |
=TRIM(B3) |
April June August |
3 |
Telephone expenses |
=TRIM(B4) |
Telephone expenses |
Can you see that it takes out the unnecessary spaces? Later on, in the case studies we will show you when this is very handy.
The formula function bar
You can see that the text starts with the spaces, but the result shown at the bottom is correct.
Things you can do with the trim formula
- Take out additional spaces in your data...contact us for more info
<-----Back to index
Next topic----->
