Suppose the data is in the B column, write in the C column the formula:
=SUBSTITUTE(B1," ","")
Copy&Paste the formula in the whole C column.
edit: using commas or semicolons as parameters separator depends on your regional settings (I have to use the semicolons). This is weird I think. Thanks to @tocallaghan and @pablete for pointing this out.
Answer from vulkanino on Stack Overflow Top answer 1 of 4
61
Suppose the data is in the B column, write in the C column the formula:
=SUBSTITUTE(B1," ","")
Copy&Paste the formula in the whole C column.
edit: using commas or semicolons as parameters separator depends on your regional settings (I have to use the semicolons). This is weird I think. Thanks to @tocallaghan and @pablete for pointing this out.
2 of 4
38
It is SUBSTITUTE(B1," ",""), not REPLACE(xx;xx;xx).
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
Leading and trailing spaces will also be trimmed to 1, but will not be removed. Select one or several columns with the data to delete spaces between words. Press Ctrl + H to get the "Find and Replace" dialog box. Press the Space bar twice in the Find What field and once in Replace With · Click on the "Replace all" button, and then press Ok to close Excel confirmation dialog.
Published April 21, 2016 Views 76K
04:33
Remove Space Between Numbers In Excel - YouTube
02:31
Remove blank spaces before and after text in EXCEL - YouTube
How To Remove Or Trim Unwanted Space Between Words ...
03:33
Quick way to remove extra (unwanted) spaces from text in Excel ...
14:47
6 Ways to Remove Extra Spaces from Text in Excel - YouTube
How to Remove Spaces in Excel Before Text - Remove Leading Spaces ...
Reddit
reddit.com › r/excel › how do i remove the space between words? example below.
r/excel on Reddit: How do I remove the space between words? Example below.
October 13, 2025 -
Patrícia Neves = patricianeves Helio of Pianti = heliodepianti Álvaro Marques = alvaromarques
I want to do this in bulk with a thousand names.
Edit: The user gutsyspirit told me the simplest way for anyone who has the same question:
Ctrl + H -> find what: space bar Replace with: does not write anything
Just press replace to adjust or replace all.
DataCamp
datacamp.com › tutorial › how-to-remove-spaces-in-excel
How to Remove Spaces in Excel: 5 Good Methods | DataCamp
March 4, 2026 - The SUBSTITUTE() function removes every space (including the space between words) from a cell and replaces any character, including spaces, with something else. It cleans numerical data, such as removing spaces that separate digits. ... Create a helper column.
TeachExcel
teachexcel.com › excel-tutorial › remove-spaces-between-text-in-excel_1477.html
3 Methods to Remove Spaces Between Text in Excel - TeachExcel.com
Type a comma again to move to the next argument and then type "" making sure that there is NO SPACE between the double quotation marks this time. This is what Excel will replace the spaces with, nothing. Hit Enter and that's it! To apply this to the entire list, simply double-click the small black square in the bottom right of the cell that you can see when cell B1 is selected in the above image; this effectively copies the function down the entire list. Notice that this has removed all spaces from all of the examples, regardless of how many spaces were in the examples.
Reddit
reddit.com › r/excel › is there any way to automatically remove unwanted spaces for text within a cell?
r/excel on Reddit: Is there any way to automatically remove unwanted spaces for text within a cell?
July 20, 2023 -
I copy text from documents into Excel and when they come through, there will be anywhere between 2 and 10 spaces between words. Is there anything I can do to get rid of those?
Thanks for the help!
Top answer 1 of 6
7
=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
2 of 6
2
I just use find and replace (ctrl+h) . In the find what box I just put a single space, leave the replace with box empty. Then replace all.
Microsoft Support
support.microsoft.com › en-us › excel › trim-function
TRIM function | Microsoft Support
This article describes the formula syntax and usage of the TRIM function in Microsoft Excel. Removes all spaces from text except for single spaces between words.
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 top cell in a blank column. To remove extra space between numbers, characters, or words in a cell, you can use the SUBSTITUTE function.
ExtendOffice
extendoffice.com › documents › excel › how to remove extra spaces between words in cells in excel?
How to remove extra spaces between words in cells in Excel?
August 6, 2024 - In Excel, you can remove extra spaces between words with TRIM.
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 To Excel
howtoexcel.org › remove-unwanted-space-characters
4 Ways to Remove Unwanted Space Characters | How To Excel
It removes all spaces from a text string except for single spaces between words. The TRIM function has one required input, and this is the text from which we want to trim off excess spaces. The input can either be a cell reference like B2 or a hardcoded string like ” Hello World!
SimonsezIt
simonsezit.com › article › remove-spaces-in-excel
How to Remove Spaces in Excel? 3 Easy Methods
November 7, 2022 - Excel has a lot of functions and formulas to help you perform certain operations. To remove unwanted spaces between texts you can use the TRIM function.
ASAP Utilities
asap-utilities.com › asap-utilities-excel-tools-tip.php
Remove Leading, Trailing, and Extra Spaces Between Words | Extra features for Excel
For example: - "Lennox Street 141 ... spaces in between " becomes "Multiple spaces in between" It works like Excel's TRIM() function but with enhancements....
Top answer 1 of 3
16
Hi Wilson,
I am working on an excel that requires me to shorten text strings by removing spaces. I use the TRIM but it still leaves a regular blank between words. What I want to do is to make " apple orange lemon" become " appleorangelemon". I wonder if there is a way to do this so I can save my time.
- Select data of interest
- Ctrl+H to open the Find & Replace dialog
- Enter a single space in the Find what box
- Delete any content fromReplace with box
- Replace all
===
Regards,
Norman
2 of 3
1
Hi Wilson,
Thank you so much. Your method works like a magic.
You are very welcome!
Thank you for the kind feedback.
===
Regards,
Norman
Indeed Career Guide
sg.indeed.com › career guide › career development › how to remove space in excel (including types of spaces)
How to Remove Space in Excel (Including Types of Spaces) | Indeed.com Singapore
September 8, 2023 - The general syntax for this function is TRIM (Text), where text represents the cell you wish to extract unwanted spaces. Using this technique, you can remove leading, trailing and extra spaces between words and enhance your writing experience.
Excel Easy
excel-easy.com › examples › remove-spaces.html
Remove Spaces in Excel - Step by Step Tutorial
The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.
Unstop
unstop.com › home › blog › remove spaces in excel: key methods to tackle different types
Remove Spaces In Excel: Key Methods To Tackle Different Types
February 3, 2025 - To address this, use the SUBSTITUTE function to replace spaces with no characters. For example, =SUBSTITUTE(A1, " ", "") will convert a number formatted with spaces into a usable numeric value, ensuring accuracy in calculations like SUM or AVERAGE.
Igmguru
igmguru.com › blog › how-to-remove-spaces-in-excel
How to Remove Spaces in Excel: 5 Best Methods
1 week ago - One of the most popular options in Excel add-in is the Trim Spaces tool. This tool is designed specifically for cleaning text data. It can remove leading spaces, trailing spaces, extra spaces between words, line breaks, and even non-breaking ...
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 - The tutorial explains how to remove blank spaces in Excel using formulas and the Text Toolkit tool. You will learn how to delete leading and trailing spaces in a cell, eliminate extra spaces between words, get rid of non-breaking white space and non-printing characters.
Trump Excel
trumpexcel.com › home › remove extra spaces in excel (leading, trailing, double spaces)
Remove Spaces in Excel - Leading, Trailing and Double
Excel TRIM function would instantly remove all the leading and trailing spaces in the cell. Once you have the cleaned data, copy it paste it as values in place of the original data. This function is also helpful if you have more than one space character between words.
Published November 2, 2015