Understand TRIM and Acknowledge 10 Examples

The Trim function remove the spaces from text, apart from a space between the words. The function allow user to trim text that have been received from another application that might have spacing that is irregular.

It is important to acknowledge that the function do not remove any non-breaking space character, because it is mainly designed to trim the 7-bit ASCII character of space from the text. This is the value 32.

Syntax and Argument

The syntax looks exactly like this: =TRIM(text). The only argument is text.

Text: this is definitely required. The text is that from which the user would want to remove spaces from.

Example 1: Simple Trim Formula

This formula is to trim a specific text on Microsoft Excel.

Simple Trim Formula

Example 2: TRIM with Multiple Space Issues

This example focuses on using the trim function with multiple spacing issues.

TRIM with Multiple Space Issues

Example 3: Trim a Cell

This example focuses on trimming texts that is in a cell.

Trim a Cell

Example 4: Trim and Find

This example focuses on trimming texts in multiple cells. It is under the circumstances that we’d have the words layout, and the texts we want to use are in different cells.

Trim and Find

Example 5: TRIM and Flexibilities

We have text in different cells, but we want to add something to it. This example focuses on trimming both cells and text.

TRIM and Flexibilities

Example 6: Trim and Left

This is the example that focuses on trimming and using data to the left. It is the acknowledgment of the letter in left, using trim and left functions simultaneously.

Trim and Left

Example 7: Trim, Right, Substitute and Rept.

This example uses four different functions – trim, right, substitute and rept. – to find a solid result with the simultaneous usage of the function.

Trim Right Substitute and Rept

Example 8: Trim, Left, Substitute, Mid, Find and Rept.

This example uses six different functions – trim, left, substitute, mid, find and rept. – to get a specific result. It is being used to eliminate some texts from the row.

Trim Left Substitute Mid Find and Rept

Example 9: Previous Example Excluding "Matter"

This example use the very same data as previous example, but this time we are excluding the word “matter” from the spreadsheet. The best part is, we are using the very same functions as the previous example – trim, left, rept., substitute, mid and find.

Previous Example Excluding Matter

Example 10: IF, ISNUMBER, FIND and TRIM

This is the example that make use of four different functions – IF, ISNUMBER, FIND and TRIM – to see if we would get a different result.