The Microsoft Company is really great that it has created such very powerful computer software known as the Microsoft Excel. Excel has a wide variety of useful functions that can be used in various ways, either by nonprofessional or even by the experts. The Excel functions offer lots of benefits to the user, whether for business, mathematical or financial use. This computer software can perform complex function that helps people make their job easier. Although most users utilize Excel for its simple functions, it still features numerous complex functions that would benefit especially those professionals in their respective specializations.
Maybe, some of you import or copy text from other applications and paste it to your Excel spreadsheet. Then, you found out that the text that’s been imported contains distracting spaces among its words. Suddenly, you would ask yourself, “Is there an Excel function that can fix the irregularities in the word spacing of any particular text?” The answer to that question is yes. Microsoft Excel also features a function known as TRIM function, which is utilized to remove those distracting spaces that can cause irregularities in your data. To learn more about this TRIM function, read on this article because it provides you the description of a TRIM function, steps on how to use it in some versions of Excel and some examples that can help to gain knowledge about this function.
Overview of a TRIM Function Meant for Microsoft Excel
If you have received, imported or pasted a text into your Excel spreadsheet which contains disturbing spaces, the Excel’s TRIM function will assist you to eliminate them. These spaces will make your data quite unprofessional. Aside from this, these spaces will interrupt when you attempt to locate duplicate values in your data since incorrect spaces will distort the results.
In Microsoft Excel, TRIM function been utilized to eliminate the entire spaces from its text. But there is an exception: the sole word spacing inside the words of the content is removed. This TRIM function’s very useful especially when you need to eliminate extra spaces between the texts that you imported from other applications. The formula required for TRIM function:
Wherein, its “text” argument refers to the text or content with irregular spaces which needs to be eliminated. Always remember that a text argument must be enclosed in double quotations.
To learn more about TRIM function, here is an example. “Hello World” is contained in cell B8 and you wish to eliminate the extra spaces from its content. Then TRIM function formula should be entered like this:
After doing that, you will notice that the extra spaces from its text are eliminated and what’s left is sole word spacing among the words.
Alternatively, you can enter in the formula the cell reference instead of using the actual text. For instance, if you prefer to eliminate the extra spaces from text contained in cell B8, then TRIM function formula should be entered like this:
For a better understanding on how to utilize a TRIM function, this article provides you a detailed procedure that you can utilize in Microsoft Excel 2007 and 2003.
How to Use TRIM Function Designed for Microsoft Excel 2007
As an example, “Angelina Jolie” is contained in cell B4.
- Click on cell C4 in your worksheet.
- Next, click on “Formulas” on the Ribbon.
- In the Function Library, click on the “Text” button and then click TRIM from the list. After doing that, the Function Arguments Dialog box will display.
- Then, click on B4.
- Finally, click the OK button.
- You will notice that all the uneven spaces from its text in cell B4 are removed.
How to Utilize TRIM Function Intended for Excel 2003
- Click on cell C4 on your worksheet.
- Adjacent to the formula bar, look for the Insert Function button and click it.
- Then click on the category list arrow and choose and click Text which you can find from the list.
- From the list of functions, click on TRIM and then click the OK button. After doing that, the Function Arguments dialog box will display.
- Click on cell B4.
- Finally, click the OK button.
Once again, you will notice that all the unequal spaces within the text are removed.
- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro