The TRIM function removes all unnecessary spaces in a sentence.
It is suitable for formatting data imported from other applications or manually inputted in large quantities.
How it works
|text||Specify the target string.|
This is an example of the result of executing the TRIM function.
The LEN function is used to display the number of characters, as it is difficult to discern visually.
All preceding and following spaces are deleted.
One space between words will be deleted.
TAB characters are not deleted, so use the CLEAN or SUBSTITUTE function.