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))
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.