Trim Excel Formula




Excel Formulas > Text Functions > TRIM

« Substitute | Trim | Upper »

What is the use of Trim formula?

Removes un-necessary spaces in a given text


Syntax of Trim formula:
trim(this text)

Examples of Excel Trim formula:
trim(" unusally spaced text ") = unusually spaced text


Buy Excel Formula E-book | Learn more about Excel Trim Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook