Remove Spaces After Text in Excel Cells with TRIM

To remove only ordinary spaces at the end of text while preserving spaces inside words, put this formula beside the original value in B2, assuming the text is in A2: =IFERROR(LEFT(A2,XMATCH(TRUE,MID(A2,SEQUENCE(LEN(A2)),1)<>" ",0,-1)),""). Fill it down, then copy the cleaned results and paste them as values if you need to replace the originals. For a quick cleanup that also removes leading spaces and reduces repeated spaces between words, use =TRIM(A2) instead.

What You’ll Need

A Microsoft Excel workbook containing the text to clean. These instructions are for Excel for Microsoft 365 on Windows.
A blank helper column beside the source data, so you can check cleaned results before replacing anything.
Excel 2021 or Microsoft 365 for the targeted trailing-space formula using XMATCH and SEQUENCE. TRIM is available in older Excel versions too.

Keep the original column until you have checked the output. A formula-based cleanup creates a result in another cell; it does not silently alter the source text. That makes it easier to compare results and recover if the cleanup changes something you wanted to keep.

Step-by-Step

Identify which spaces you want to remove. Trailing spaces are ordinary spaces after the final visible character, such as the spaces after “North” in a cell that contains “North ”. They can make two entries look identical while Excel treats them as different text. Decide whether you want to remove only those spaces or also tidy the spaces at the beginning and between words. The distinction matters: TRIM changes more than just the end of a cell.
Make a helper column. If your text is in A2:A100, select B2 and use that column for the cleaned results. Add a header such as “Cleaned text” in B1 if that helps you keep track. Avoid entering the formula over the original data; a reference to the original cell is needed while the formula is being calculated.
Enter a formula for trailing spaces only. With the source text in A2, enter =IFERROR(LEFT(A2,XMATCH(TRUE,MID(A2,SEQUENCE(LEN(A2)),1)<>" ",0,-1)),"") in B2. Press Enter. This checks characters from the end of the text and returns everything through the last character that is not an ordinary space. For example, if A2 contains “North ”, B2 displays “North”. If A2 contains “North Ridge ”, the space between the words remains, while the spaces after “Ridge” are removed. The IFERROR wrapper returns a blank if the cell is empty or contains only spaces.
Fill the formula down the list. Select B2 and move the pointer to the small square at the lower-right corner of the selection, called the fill handle. Drag it down through the rows that contain source text. Alternatively, copy B2, select the matching cells in column B, and paste. On Windows, Ctrl+C copies and Ctrl+V pastes; on Mac, use Command+C and Command+V. Check that each row refers to the corresponding source cell, such as A3 in B3 and A4 in B4.
Check the cleaned values. Compare several results with their source cells, including entries that have multiple words, punctuation, numbers stored as text, and blank cells. The trailing-only formula preserves leading spaces and repeated spaces inside the text. If those are unwanted too, use the TRIM option described in the next step. Look for unexpected blanks or errors before changing the source column.
Use TRIM when you want broader cleanup. With the source text in A2, enter =TRIM(A2) in B2 and fill down. TRIM removes ordinary leading and trailing spaces and reduces multiple ordinary spaces between words to one. For example, “ North Ridge ” becomes “North Ridge”. That is useful for tidying names or labels, but it is not a trailing-only fix because it also changes spacing inside the text.
Replace the original data only after checking it. If the cleaned column is correct and you want fixed text rather than formulas, select the results and copy them. Select the first original cell, then choose Home > Paste > Paste Values. This writes the displayed text into the original cells instead of formulas that depend on the helper column. On Windows, Ctrl+C copies and Ctrl+V opens the usual paste options; on Mac, use Command+C and Command+V, then choose Paste Values from the paste options or Home ribbon. Keep a backup or a copy of the original column until you are satisfied.

The trailing-only formula uses XMATCH and SEQUENCE, which are available in Excel 2021 and Microsoft 365. If you use an older Excel release, or simply do not need to preserve unusual internal spacing, =TRIM(A2) is a widely compatible alternative. Remember that the formula result is calculated text: use Paste Values if you need to remove the formulas while keeping the cleaned text.

Common Mistakes

Using TRIM when only the ending spaces should change. TRIM also removes leading spaces and turns runs of ordinary spaces between words into single spaces. Use the targeted formula when internal spacing must remain exactly as entered.
Expecting a formula to edit its own source cell. A formula in B2 can clean A2, but a formula cannot safely replace the value in A2 while also referring to A2. Work in a helper column, verify the output, and paste values over the source only when ready.
Overwriting the original before checking the results. Pasting values over the source is difficult to reverse after you close the workbook or make further edits. Keep a copy of the original column or save a separate workbook first.
Assuming every invisible character is an ordinary space. TRIM and the targeted formula above look for the regular space character. A nonbreaking space, tab, line break, or other imported character may remain, even if it looks like a space on screen.
Filling the formula into the wrong rows. If the source has a header or blank rows, check the first and last references before filling down. Make sure B2 refers to A2, not to a different row or column.

Tips

Choose the method based on the data. For text copied from a website or system where internal spacing is meaningful, use the trailing-only formula. For inconsistent names with extra spaces at both ends and between words, TRIM is often the better choice.
Use a small test before cleaning a large range. Try one value with no ending space, one with several ending spaces, one with two words, and one blank. The results show whether the chosen formula fits your data before you fill an entire column.
Retain the helper column until dependent work is checked. Formulas elsewhere in the workbook may refer to the original cells. After pasting values, review key lookups, comparisons, or reports that use the data. Cleaning trailing spaces can make text matching more consistent, but it cannot fix unrelated differences such as spelling or punctuation.
Use Find and Replace cautiously. Replacing a space with nothing throughout a selected range removes spaces between words as well as spaces at the end. It is not a safe substitute for trimming trailing spaces unless every space in the selection should be deleted.
Check for nonbreaking spaces in imported text. These often come from web pages and can look like normal spaces. If you have confirmed that the unwanted character is a nonbreaking space, a separate SUBSTITUTE step can replace it. With the imported text in A2, use =SUBSTITUTE(A2,CHAR(160)," ") in a helper cell, then apply TRIM or the trailing-only cleanup to that result. CHAR(160) represents the nonbreaking space; replacing it with an ordinary space makes it easier to clean.

Troubleshooting

The formula returns #NAME? or Excel does not recognize XMATCH. Your Excel version may not include XMATCH or SEQUENCE. Use =TRIM(A2) if its broader spacing changes are acceptable, or open the workbook in Excel 2021 or Microsoft 365. Do not remove functions from the formula at random; each part is needed for the trailing-only check.

The visible spaces remain after cleanup. They may be nonbreaking spaces, tabs, line breaks, or a font or display issue rather than ordinary trailing spaces. Try the CHAR(160) replacement described above if the text came from a web page. If the source may contain tabs or line breaks, inspect a sample and identify the character before replacing it; broad replacements can alter legitimate content.

The result is blank even though the cell appears to contain text. Check whether the source cell contains only ordinary spaces. The targeted formula intentionally returns blank for a cell with no non-space characters. Also check that the formula points to the correct source cell and that the text is not in another column.

Internal spacing changed unexpectedly. That is normal for TRIM when there are multiple ordinary spaces between words. If those spaces need to stay as entered, undo the change with Ctrl+Z on Windows or Command+Z on Mac if it is still available, restore the source if necessary, and use the trailing-only formula instead.

The cleaned text reverts or changes when you remove the helper column. The results are formulas that refer to the source. Before deleting the helper column, copy its results and paste values into the destination cells. Confirm the values are present before removing the helper column.

Frequently Asked Questions

How do I remove only spaces at the end of a cell?
Use the XMATCH and SEQUENCE formula in the first method, then fill it down. It removes ordinary trailing spaces while preserving leading spaces and spaces within the text.

Does TRIM remove spaces at the end of text in Excel?
Yes. TRIM removes ordinary spaces at the beginning and end and reduces repeated ordinary spaces between words to one. Use it when that broader cleanup is wanted.

Can I remove trailing spaces without a formula?
For one or a few cells, you can edit the cell, place the cursor after the final visible character, and remove spaces with Backspace or Delete. For many rows, a helper-column formula is easier to check and repeat consistently.

Why does TRIM not remove every blank-looking character?
TRIM targets ordinary space characters, not every character that can look blank. Nonbreaking spaces, tabs, and line breaks may need a specific replacement or cleanup after you identify what the cell contains.

Will removing spaces change numbers or dates?
Text formulas return text results. If a cell contains numbers or dates stored as text, check the result and number format before using the values in calculations. If you need numeric values, convert them deliberately after cleaning rather than assuming the formula has preserved a numeric data type.

Can I clean a whole column at once?
Yes. Enter the formula beside the first data row, fill it down through the used rows, check the results, and paste values if you need to replace the source. Avoid applying it to an entire million-row column unless necessary, since that creates many formulas and can slow the workbook.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.