How To Use TRIM Function | Microsoft Excel

how to use trim function

TRIM function will remove the additional spaces in the cell and leave the content with one space between the words. TRIM function converts text from irregular spaces to regular spaces between the words

Syntax of TRIM Function


Arguments of TRIM Function

text: text which you want to remove additional spaces

Behavior of TRIM Function

Here you can see the spaces between the words and line break, which is removed by TRIM function

Usage of TRIM Function

To remove additional spaces from the text.

Return of TRIM Function

Regularly spaced text

1 comment:

  1. Short-term savings on doing work one's self are often dwarfed by the long-tem cost of attempting to repair a tree from improper pruning. Stump Removal