Super Easy Excel TRIM Function Tips You Might Not Know

Removing spaces in an Excel file is not as difficult as you might think. With the TRIM function in Excel, spaces can be quickly and easily removed. Let’s learn how to use this function in the article below.

What is the TRIM function in Excel? Application of the function in Excel

During your studies or work, you may come across situations where you need to remove spaces in an Excel file. However, manually deleting spaces can be time-consuming and affect your work progress. In that case, the TRIM function in Excel can help you solve this problem.

The TRIM function in Excel is a function that removes unnecessary white spaces in text and leaves only the necessary spaces between words. Specifically, the function takes a series of words and returns a string of those words without spaces at the beginning, end, or between them.

Applications of the TRIM function

• Helps improve the aesthetic presentation of text by removing unnecessary spaces.
• Convenient for studying and working.
• Can be combined with many other functions in Excel.

How to use the TRIM function in Excel

Using the TRIM function in Excel is very simple. Below, we will introduce you to the syntax and usage of the function.

TRIM function syntax

In the reference cell in Excel, you enter the function =TRIM(text).

Where:

• The = sign: executes the command and displays the answer.
• TRIM: the command that performs the function.
• text: The data cell containing the text with spaces to be removed.

How to use the TRIM function in Excel

For better understanding, suppose you have a data table that needs to remove spaces. The steps to use the TRIM function are as follows:

Step 1: Enter the function TRIM(B2) in the data cell where you want the result to be displayed. Here, we use cell B2 as a reference cell.

Step 2: Press Enter to display the result and move the mouse to the lower right corner of the data cell to show the drag and drop operation. Immediately, the function will be copied to the cells below and automatically display the result for these cells.

With just a few simple steps, you can apply the TRIM function to enhance the aesthetics of your text.

Combine the TRIM function with the CONCATENATE function in Excel

If you have 3 data cells that need to be linked together, remember the formula of combining the TRIM function with the CONCATENATE function to save time.

Step 1: Enter the function CONCATENATE(TRIM(B2) ” “,C2) and the cell where you want the result to be displayed. In which:

C2: The cell containing the data to be concatenated.

” “: The space mark indicates the space between the data you want to connect. If this space is missing, the characters will stick together.

TRIM(B2): The function removes extra spaces at cell B2, leaving only spaces between words.

Step 2: Press Enter to display the result and move the mouse to the bottom right corner of the result cell to perform the drag operation. Instantly, the result cells below will be displayed.

Combining these two functions together will help you quickly and accurately handle the situation of scattered data cells.

Combining Trim with the “&” to concatenate strings

In addition to linking functions together, you can also use the TRIM function combined with the special character “&”.

Step 1: Enter the function =TRIM(B2)&” “&C2 in the reference cell where you want the result to appear. The ” “ is the space between the data you want to concatenate. If there is no space, your data will be stuck together.

Step 2: Press Enter to display the result and drag the mouse down to copy the function to the cells below.

Summary

The above article provides you with how to use the TRIM function in Excel with many practical examples. Hopefully, you have gained useful knowledge and can apply it in your daily work and study. Good luck with your successful implementation.

If you are looking for a computer that can serve well for work, study, and run Excel smoothly, please refer to the products available at FPT Shop.

Refer to many models of laptops at good prices and powerful configurations Laptop

• How to use the TODAY function in Excel
• How to use the OR function in Excel that not everyone knows
• 3 ways to use the Random function in Excel that you should know

You may also like

5 Essential Excel Functions for Beginners

Master the fundamentals of Excel with these 5 basic functions! Learn how to use SUM, AVERAGE, COUNT, MIN, and MAX in order to make calculating and analyzing data easier and more efficient.

A Simple Method for Adding Watermark to Excel for All Spreadsheets in No Time

Watermarking in Excel is a great way to mark your ownership and protect the content on your Excel spreadsheets. If you’re unsure how to do it, you can follow the steps outlined in this article.

How to recover unsaved or overwritten Excel files effectively: a sure-fire method

Knowing how to recover unsaved Excel files can be extremely helpful in cases when your computer unexpectedly shuts down or you accidentally click on “Don’t save” when Excel asks if you want to save your changes before closing. Follow this article to learn the step-by-step process of how to accomplish it.