What's the use of TRIM function?

Question

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

Muhammad Jamil Akhtar · Answer

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

PHILIP MALINAO · Answer

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 · Answer

It eliminates extra spaces within cell/s.

Shahnawaz Alam Shahnawaz · Answer

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 · Answer

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 · Answer

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.

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

What's the use of TRIM function?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة