Register now or log in to join your professional community.
TRIM function removes all spaces except single spaces between words. The TRIM function is expecting a single value. When we give TRIM a range of values we must use Ctrl + Shift + Enter to put formula in cell. Range of values in a function argument that is expecting a single value becomes an array formula. TRIM converts numbers to text. to get the number back to a number Add 0 (zero).
It returns a text value with the leading and trailing spaces removed. You can also use the TRIM function to remove unnecessary spaces between words in a string.
It eliminates extra spaces within cell/s.
Trim function remove extra space from cell. Sometime trim function do not remove extra space then use substitute function like trim(substitute(A1,char(160),char(32))
