Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What's the use of TRIM function?

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).

user-image
Question ajoutée par Mahmoud Hamid , Finance Manager , Experts
Date de publication: 2013/04/30
Muhammad Jamil  Akhtar
par Muhammad Jamil Akhtar , Principal , Education Deptt. Govt. of the Punjab. Pakistan

For being more beautiful and attractive this function is carried out.Either they are ladies, plants, trees or animals.

PHILIP MALINAO
par PHILIP MALINAO , Fleet Controller-Operation Supervisor , United Global Services (TM.Co)

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.

Faiyazuddin Mohammed
par Faiyazuddin Mohammed , Research Associate , Cognizant (UBS Service Centre India Pvt. Ltd)

It eliminates extra spaces within cell/s.

Shahnawaz Alam Shahnawaz
par Shahnawaz Alam Shahnawaz , Database Specialist , Intigral

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))

Sohaib Abbas Sohaib
par Sohaib Abbas Sohaib , Group Accounting Manager – Consolidation and Reporting , Arasco

More over some times Vlookup or hlookup formula dont work if there are some spaces after the word finish so trim it and then formula will work

Mike Emerson Pasaron
par Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

TRIM is one of the functions that help you clean and organize data especially when copying tables from a database or from word processing applications like MS word.
TRIM removes the extra spaces aside for the space between words.

More Questions Like This