Learn how to use the TRIM function in Excel to remove all spaces from text except for single spaces between words. See the syntax, usage, and examples of the TRIM function.

Learn how to use these functions to remove leading, trailing, or both types of spaces from a string expression in Excel. See syntax, examples, and VBA code for each function.

The TRIMRANGE function scans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columns.

Lists Text functions, such as the Clean, Proper, and Trim functions.

Lists all Excel functions by their category, such as Logical functions or Text functions.

Add-in and Automation: Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation). This function is not available in Excel for the web.

Because these characters are not easily noticed, the unexpected results may be difficult to understand. To remove these unwanted characters, you can use a combination of the TRIM, CLEAN, and SUBSTITUTE functions.

This article shows you how to extract various components from a variety of name formats using these handy functions. You can also split text into different columns with the Convert Text to Columns Wizard.

This article describes the formula syntax and usage of the TRIMMEAN function in Microsoft Excel. Description Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.