Microsoft Support
support.microsoft.com › en-us › excel › trim-function
TRIM function | Microsoft Support
Example 3: =TRIM(CLEAN(B5)) combines TRIM and CLEAN functions to remove spaces and clean string. Example 4: Copy the example data in the following table and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › excel trim function - quick way to remove extra spaces
Excel TRIM function - quick way to remove extra spaces
March 20, 2023 - With Ultimate Suite installed in your Excel, removing spaces in Excel is as simple as this: Select the cell(s) where you want to delete spaces. Click the Trim Spaces button on the ribbon.
How can I remove extra space from the text
Try TRIM() More on reddit.com
9
1
October 13, 2022Is there any way to automatically remove unwanted spaces for text within a cell?
=TRIM function If you don't want the formula in the cell afterwards, use the trim function, copy the text afterwards, and then use paste special to paste only text without formula More on reddit.com
18
9
July 20, 2023How To Remove Spaces in Excel (When TRIM Doesn't Work!)
01:57
How to Remove Extra Blank Spaces in Microsoft Excel (TRIM Function) ...
05:07
Using the Trim Function in Excel - YouTube
07:49
Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?) - YouTube
02:18
Remove Spaces With Excel TRIM Function - YouTube
02:00
How to Delete Trailing Spaces in Excel : MS Excel Tips - YouTube
Macabacus
macabacus.com › home › how to trim cells in excel
How to Trim Cells in Excel (Downloadable Template)
November 18, 2025 - For instance, if you would like to remove all dashes (“-”) from a cell and then trim the remaining spaces, you should enter: =TRIM(SUBSTITUTE(A11,”-“,””)). Combining the above functions with TRIM enables you to make powerful ...
Acuity Training
acuitytraining.co.uk › news-tips › trim-function-excel
Excel's TRIM Function [inc 2 Examples & Troubleshooting] - Acuity Training
February 2, 2026 - It’s especially handy when cleaning data imported from other sources. To find the TRIM function, go to the top of the ribbon on your screen. Click Formulas > Text, and scroll down to the TRIM function button.
ExcelDemy
exceldemy.com › home › excel functions › how to trim spaces in excel (8 methods)
How to Trim Spaces in Excel (8 Methods) - ExcelDemy
July 28, 2024 - Drag the button to where you want it and assign a caption (e.g., “Trim Trailing Spaces”). ... Choose the macro name (Trim_Trailing_Spaces). Select the workbook containing the macro (e.g., Excel Trim Spaces.xlsm).
MelComTech
melcompton.com › home › how to use the trim function in excel: remove extra spaces from your data
How to Use the TRIM Function in Excel: Remove Extra Spaces from Your Data
September 10, 2024 - Find an empty column next to your data where you’ll apply the TRIM function in Excel. Click on any empty cell (for example, let’s use D2). Now, click on the fx button (Insert Function) located to the left of the formula bar.
Ablebits
ablebits.com › docs › excel-trim-spaces
How to use Trim Spaces tool for Excel
Here you will learn how to remove spaces in Excel. We care about your data. The add-in will back up your worksheet if you select the corresponding option. To run the tool, click the Trim Spaces icon in the Text group on the Ablebits Data tab:
MakeUseOf
makeuseof.com › home › productivity › how to remove spaces in excel
How to Remove Spaces in Excel
October 22, 2021 - In the first cell of the Helper column, enter the Excel formula to remove spaces =TRIM (A2).
Indeed
uk.indeed.com › career-advice › career-development › how-to-remove-space-in-excel
How to remove space in Excel using 5 different methods | Indeed.com UK
June 16, 2026 - You can alter this formula to remove space from other cells featured within the spreadsheet. Another usage of the TRIM function can refer to clearing up space within individual cells. For example, =TRIM(A1) removes any excess space from the A1 cell and can be easily adapted for use elsewhere. If you want to remove space in Excel, you can use the substitute function.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › how to remove blank spaces in excel - leading, trailing, non-breaking
How to remove blank spaces in Excel - leading, trailing, non-breaking
March 20, 2023 - If the Trim/Clean formula joins the contents of multiple lines without spaces, you can fix it by using one of these techniques: Utilize the "Replace All" feature of Excel: in the "Find what" box, input a carriage return by pressing the Ctrl+J shortcut; and in the "Replace with" box, type a space. Clicking the Replace All button will swap all line breaks in the selected range for spaces.
W3Schools
w3schools.com › excel › excel_trim.php
Excel TRIM Function
The TRIM function is premade in Excel and used to remove irregular text spacing and keep single spaces between words.
Ablebits
ablebits.com › ablebits blog › excel › excel formulas › 3 ways to remove spaces between words / numbers in excel cells
3 ways to remove spaces between words / numbers in Excel cells
Replace the original column with the one that has the cleaned data. Select all cells in the helper column and press Ctrl + C to copy data to clipboard. Now pick the first cell in the original column and press Shift + F10 or the menu button .
Published April 21, 2016 Views 76K
Wall Street Mojo
wallstreetmojo.com › home › all blogs › excel resources › trim in excel
TRIM in Excel - How To Use? Formula, Errors, Examples, Template
December 20, 2024 - The output is “John Wright” after applying the TRIM formula as =TRIM(A1), as shown above in cell B1. ... The TRIM in Excel removes extra spaces from the text, leaving no extra space between words and at the beginning and end of the string.
Indeed
uk.indeed.com › career-advice › career-development › trim-function-excel
How to use the trim function in Excel (With benefits) | Indeed.com UK
March 3, 2025 - The following formula will appear in the adjacent cell:=TRIM (cell where you entered the text)Press 'OK' to complete the process. The adjacent cell now displays your text without the unnecessary spaces.
Corporate Finance Institute
corporatefinanceinstitute.com › home › resources › trim function
TRIM Function - Formula, Examples, How to Use TRIM in Excel
May 11, 2026 - It cleans up data by eliminating leading, trailing, and intervening spaces, useful for data imported from other sources. The function uses the formula =TRIM(text) and only removes ASCII space characters.
Lifewire
lifewire.com › remove-extra-spaces-between-data-3123367
Do You Know the Short Cut to Remove Extra Spaces in Excel?
May 5, 2022 - Type =TRIM(B2) and press Enter. Hold down the Shift key, and hover your mouse at the bottom of cell B2 until the cursor changes to two horizontal lines with an arrow above and below them.
Yacostasolutions
yacostasolutions.com › home › remove spaces in excel: how to use the trim function (+ video tutorial)
Remove Spaces in Excel: How to Use the TRIM Function (+ video tutorial)
The TRIM function gets rid of spaces from the beginning + end of a cell in Excel. See step-by-step instructions of how to use TRIM in Excel.
Published November 6, 2023
DataCamp
datacamp.com › tutorial › how-to-remove-spaces-in-excel
How to Remove Spaces in Excel: 5 Good Methods | DataCamp
March 4, 2026 - The TRIM() function removes unnecessary ... to the TRIM() function in Excel. Here's how to use it: Create a helper column next to your data. In the first cell of the helper column, enter the formula: =TRIM(A2)....
Spreadsheet Planet
spreadsheetplanet.com › home › excel functions › trim function
How to Use TRIM Function in Excel (5 Easy Examples)
May 29, 2026 - Clear the spill range, or move the formula somewhere with empty cells underneath. Watch out for the @ implicit intersection. A workbook saved by an older Excel version sometimes auto-injects an @ symbol (e.g. =@TRIM(A2:A100)), which collapses the spill back to a single cell. Remove the @ and the spill comes back. Use Find and Replace for one-off cleanup. If you only need to clean a small range, Ctrl+H to replace double spaces with single spaces is faster than writing a formula.
Top answer 1 of 6
242
Quite often the issue is a non-breaking space - CHAR(160) - especially from Web text sources -that CLEAN can't remove, so I would go a step further than this and try a formula like this which replaces any non-breaking spaces with a standard one
=TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160)," ")))
Ron de Bruin has an excellent post on tips for cleaning data here
You can also remove the CHAR(160) directly without a workaround formula by
- Edit .... Replace your selected data,
- in Find What hold
ALTand type0160using the numeric keypad - Leave Replace With as blank and select Replace All
2 of 6
142
If you would like to use a formula, the TRIM function will do exactly what you're looking for:
+----+------------+---------------------+
| | A | B |
+----+------------+---------------------+
| 1 | =TRIM(B1) | value to trim here |
+----+------------+---------------------+
So to do the whole column...
1) Insert a column
2) Insert TRIM function pointed at cell you are trying to correct.
3) Copy formula down the page
4) Copy inserted column
5) Paste as "Values"
Should be good to go from there...