=trim() should work Answer from a_gallon_of_pcp on reddit.com
DataCamp
datacamp.com › tutorial › how-to-remove-spaces-in-excel
How to Remove Spaces in Excel: 5 Good Methods | DataCamp
March 4, 2026 - You need to turn the text back into a number to fix this. To do so, you can either multiply by 1 or use this formula: ... This removes spaces and ensures Excel treats the data as numbers. Combine VALUE() and TRIM() to remove spaces before numbers.
Reddit
reddit.com › r/excel › how to remove spaces before numbers
r/excel on Reddit: How to remove spaces before numbers
November 10, 2024 -
When i copy and paste a table with numbers from an email to excel, there will be spaces before the numbers. Is there an easy formula to remove these spaces (i tried to add an image, but my post was removed)
Edit: thank you all for the support. The following formula solved it
=0+SUBSTITUTE(B2,CHAR(160),"")
Edit 2:
u/semicolonsemicolon & u/Joe3453 deserves credit for recognizing nbsp being the issue.
For curious lurkers: https://en.wikipedia.org/wiki/Non-breaking_space
Top answer 1 of 12
36
=trim() should work
2 of 12
5
So we know what we're dealing with can you try =CODE(MID(B2,SEQUENCE(1,LEN(B2)),1)) and fill down and then show us the result?
How to remove all spaces and new line breaks after the last word in a cell Mar 1, 2024
r/excel 2y ago
Remove space(s) before a numerical value within a cell
Trying to remove the space in front of the number '1' in cell A2. So value in cell A2 is = " 1" TRIM function does not work for removing the space before the 1. Any ideas please? More on mrexcel.com
18
0
August 1, 2011Excel - deleting space from numbers - Stack Overflow
I have a dataset that I've copy pasted into Excel and some numbers have spaces between them. This is subset of a column in the spreadsheet: As you can see in the 3rd, 4th, 5th, 9th and 10th rows t... More on stackoverflow.com
Remove spaces before and after the word in Cell
Hi I am looking for a code to remove the spaces before and after the words in cells in column B. Can anyone help me on this Excel file attached in the below link Remoe spaces before and after the word in Cell.xlsx Thanks in advance More on learn.microsoft.com
8
366
Remove Space Between Numbers in Excel
I know this is a very basic function but even after searches and a YouTube video, I can’t seem to find how to do this and funny, I’ve done it before… I need to remove the spaces in a row…I’ve tried following examples of the TRIM function but it just doesn’t seem to be working ... More on community.spiceworks.com
7
6
February 13, 201804:33
Remove Space Between Numbers In Excel - YouTube
02:31
Remove blank spaces before and after text in EXCEL - YouTube
03:05
How to Remove Space before numbers in Excel - YouTube
01:38
Excel Tips - Removes Extra Spaces | TRIM Function - YouTube
07:18
EXCEL Remove Spaces Before and After Text - YouTube
09:30
How to Change Case and Remove Spaces in an Excel Spreadsheet - YouTube
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
The easiest way to get rid of excess spaces is using the standard Excel Find & Replace option: Press Ctrl + Space to select all cells in a column. Press Ctrl + H to open the "Find & Replace" dialog box.
Published April 21, 2016 Views 76K
WPS Office
wps.com › academy › how-to-remove-space-before-text-in-excel-quick-tutorials-1864698
6 Easy Ways to Remove Leading Spaces in Excel [2026] | WPS Office Academy
March 27, 2025 - ... 1. Select the cell or range of cells containing the data you want to clean. The below names have spaces between the first and last names. ... 2. In a blank cell, enter the formula =TRIM(A2), where A2 is the cell containing the first data point.
ExcelDemy
exceldemy.com › home › excel basics › how to remove a space before numbers in excel (3 easy ways)
How to Remove a Space before Numbers in Excel (3 Easy Ways) - ExcelDemy
May 3, 2024 - Select cell D5 and insert the following formula. ... Press Enter and utilize the AutoFill tool to fill the entire column. Select the data where you want to remove space before numbers.
The Bricks
thebricks.com › home › resources › how to remove spaces in excel before numbers
How to Remove Spaces in Excel Before Numbers
April 22, 2025 - This powerful formula first removes any non-breaking spaces, then trims regular spaces, and finally converts the final result into a true number. Cleaning up pesky leading spaces in Excel is a common but crucial task.
Excel Insider
excelinsider.com › home › our blog › excel pro tips › how to remove space before numbers in excel (5 suitable ways)
How to Remove Space Before Numbers in Excel (5 Suitable Ways) - Excel Insider
February 3, 2026 - For best results on messy data, combine both using the formula =VALUE(TRIM(CLEAN(B2))) to clean and convert at once. In this tutorial, we learned multiple ways to remove space in Excel before numbers, including formulas like TRIM, VALUE, FIND ...
MrExcel
mrexcel.com › forums › question forums › excel questions
Remove space(s) before a numerical value within a cell | MrExcel Message Board
August 1, 2011 - The offending character may not be a standard char 32 space. What result do you get with this formula: =CODE(A2) That will return the character code of the offending character. Once we know that we'll have a better idea of how to kill it! ... Thank you everybody but it looks like the issue is because my colleague has OLD exel and I have NEW excel...
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 - Select all cells with Trim formulas (B2:B8 in this example), and press Ctrl+C to copy them. Select all cells with the original data (A2:A8), and press Ctrl+Alt+V, then V. It is the paste values shortcut that applies the Paste Special > Values · Press the Enter key. Done! As you have just seen, the Excel TRIM function removed all extra spaces from a column of text data without a hitch. But what if your data is numbers, not text?
Wikihow
wikihow.com › computers and electronics › software › office › spreadsheets › microsoft excel › how to remove spaces between numbers & words in excel
How to Remove Spaces Between Numbers & Words in Excel
September 13, 2024 - Click the first cell in the column with spaces. For example, if the first cell in the column that has extra spaces is A1, click it now. If you clicked cell A1, the formula should now look like this: =SUBSTITUTE(A1 .
Top answer 1 of 4
1
- Highlight the range that you want to modify
- CTRL + F
- Click Replace
- "Find what: " (put a blank space here so it searches for spaces)
- "Replace with: " (leave this blank)
- Click Replace all, and the selected range should search for blank spaces and replace them with nothing
2 of 4
1
There are two functions you can use for replacing a character in a string: Replace() and Substitute():
Replace()can be used when you know where you want to replace whatever.Substitute()can be used if you know exactly what you want to replace anywhere.
So, in this case:
=SUBSTITUTE(C2," ","")
TechBloat
techbloat.com › home › how to remove a space before numbers in excel (3 easy ways)
How to Remove a Space before Numbers in Excel (3 Easy Ways) - TechBloat
November 29, 2025 - Learn how to effortlessly remove extra spaces before numbers in Excel with three simple methods: using TRIM, SUBSTITUTE, and text functions. These quick techniques ensure your data is clean and properly formatted for accurate analysis and presentation.
Excel University
excel-university.com › home › blog › how to remove leading spaces in excel
How to Remove Leading Spaces in Excel - Excel University
January 17, 2023 - Then, use the Excel fill handle to drag that formula down through the rest of the table. The range in this example is C2:C6. The Excel TRIM function will automatically eliminate all of the cell’s leading and trailing spaces.
Top answer 1 of 7
4
If trim isn’t working for you, why not do a simple find and replace of the “space” character. That may well work for you.
2 of 7
6
I know this is a very basic function but even after searches and a YouTube video, I can’t seem to find how to do this and funny, I’ve done it before…
I need to remove the spaces in a row…I’ve tried following examples of the TRIM function but it just doesn’t seem to be working correctly…
Here’s what the numbers look like:
I have about 280 of these and only need the spaces removed from those numbers all in the same column.
Thanks…
Spreadsheet Planet
spreadsheetplanet.com › home › how to remove space before text in excel
How to Remove Space before Text in Excel (5 Easy Ways)
May 12, 2026 - This is essentially the same code that uses a For Next loop to go through each cell in the selection and apply the LTRIM formula in each cell. The good thing about this immediate window method is that it’s quick and does not require you to insert a module or save the file as a macro-enabled file. All you need is this single line of code that you can use in any Excel workbook, and once you have used it to remove the space character before the text, you can close the VBA editor.
Top answer 1 of 2
3
TRIM will remove leading and trailing spaces, but not ones in the middle.
SUBSTITUTE does work, however, if we assume that all you want to do is remove all spaces:
=SUBSTITUTE(A1; " "; "")
If SUBSTITUTE fails to remove all the spaces, it may be because they are non-breaking -- see this answer.
Note that it's not necessary to use TRIM prior to using SUBSTITUTE if the space characters are all the same. It's also possible to chain SUBSTITUTE with itself -- refer to the linked answer for an example.
SUBSTITUTE can also be modified to target only specific instances.
2 of 2
0
I was able to remove the leading and trailing by using the following code. Where cell A1 contains the value that you are trimming:
=TRIM(SUBSTITUTE(A1,CHAR(160),CHAR(32)))
After you will have to copy and paste the value to remove the formula, unless someone else knows how to do that automatically.
UPDF
updf.com › home › get to know how to remove space before text in excel in 3 effective ways
Steps Guide To Remove Space Before Text in Excel | UPDF
August 25, 2025 - Trim, Substitute, and Replace are the 3 easiest solutions to remove space before text in Excel. Here you can delete spaces instantly.
MrExcel
mrexcel.com › forums › question forums › excel questions
How to remove the spaces before and after the numbers | MrExcel Message Board
June 28, 2018 - Hi there, We could always remove the first and last character of the given string like this: =LEFT(MID(A1,2,LEN(A1)),LEN(A1)-2) This formula will return the string without the first character on the left and the first character on the right, ...