TRIM Function removes all spaces from text except for single spaces between words.
When you copy or download text from other software applications like Tally, Income tax Portal, GSTN, etc into Excel, you may have irregular spacing in the text. It is very useful in situations of huge volume of irregular spacing data in excel tables.
The TRIM function syntax has the following arguments:
The function works as follows:
When you copy or download text from other software applications like Tally, Income tax Portal, GSTN, etc into Excel, you may have irregular spacing in the text. It is very useful in situations of huge volume of irregular spacing data in excel tables.
Syntax
TRIM(text)The TRIM function syntax has the following arguments:
- Text Required. The text from which you want spaces removed.
The function works as follows:
