remove spaces between words in excel

Excel formula to remove space between words in a cell

stackoverflow.com › questions › 9190764 › excel-formula-to-remove-space-between-words-in-a-cell

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

Stack Overflow

stackoverflow.com › questions › 9190764 › excel-formula-to-remove-space-between-words-in-a-cell

Excel formula to remove space between words in a cell - Stack Overflow

Top answer

1 of 4

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.

2 of 4

It is SUBSTITUTE(B1," ",""), not REPLACE(xx;xx;xx).

Delete from a String: All Words that Appear in a Column in Excel

excel - How to remove spaces in between text?

string - How can I remove ONLY leading and trailing spaces while leaving spaces in between words alone with an excel formula?

excel - Trimming spaces

google sheets - How can I remove white spaces between words?

More results from stackoverflow.com

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

=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

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.

Discussions

Is there a way to remove all spaces between text string?

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge ... 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 ... More on learn.microsoft.com

learn.microsoft.com

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

community.spiceworks.com

February 13, 2018

Remove leading and trailing spaces keeping multiple spaces between words intact

Note: This feature may not be available in some browsers. Live Online Excel Training for Your Team from MrExcel. Bring MrExcel to your people. Two hours. High-impact. Zero travel. Click here for details. If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password. ... How can I remove leading and trailing spaces keeping multiple spaces between words ... More on mrexcel.com

mrexcel.com

October 10, 2022

Cannot remove invisible spaces between words

The easiest way would be to find out what that character is and substitute it. Can you paste the text into a website like this: https://checkserp.com/encode/unicode/ More on reddit.com

r/excel

June 20, 2025

Videos

04:33

YouTube

Remove Space Between Numbers In Excel - YouTube

Remove blank spaces before and after text in EXCEL - YouTube

April 19, 2024

youtube.com

How To Remove Or Trim Unwanted Space Between Words ...

03:33

YouTube

Quick way to remove extra (unwanted) spaces from text in Excel ...

January 25, 2021

14:47

YouTube

6 Ways to Remove Extra Spaces from Text in Excel - YouTube

How To Remove Or Trim Unwanted Space Between Words (Use The Trim ...

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.

Microsoft Learn

learn.microsoft.com › en-us › answers › questions › 4981835 › is-there-a-way-to-remove-all-spaces-between-text-s

Is there a way to remove all spaces between text string? - Microsoft Q&A

Top answer

1 of 3

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

Hi Wilson,

Thank you so much. Your method works like a magic.

You are very welcome!

Thank you for the kind feedback.

===

Regards,

Norman

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

04:17

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

Spiceworks

community.spiceworks.com › software & applications

Remove Space Between Numbers in Excel - Software & Applications - Spiceworks Community

Top answer

1 of 7

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

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…

Find elsewhere

Google Bing Mojeek

Facebook

facebook.com › groups › msexcelexpert › posts › 1423512304985158

How to remove spaces between numbers and word in Excel?

We cannot provide a description for this page right now

Super User

superuser.com › questions › 1234703 › how-to-remove-spaces-between-words-using-vba-xcel

microsoft excel - How to remove spaces between words using vba xcel - Super User

Top answer

1 of 3

Consider:

Sub NoSpace()
    Dim sh As Worksheet
    For Each sh In Sheets
        sh.Range("A1").Replace what:=" ", replacement:=""
    Next sh
End Sub

2 of 3

VBA:

Dim cellText As String
cellText = [Get Cell Text From Worksheet]
cellText = Replace(cellText," ", "")

Formula:

=SUBSTITUTE(A1," ","")

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....

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.

Browserling

browserling.com › tools › remove-all-whitespace

Remove All Whitespace - Delete Spaces, Tabs, Newlines - Online - Browserling Web Developer Tools

Useful, free online tool that removes all spacing. No ads, nonsense, or garbage, just a whitespace deleter. Press a button – get the result.

Atlassian

atlassian.com › data › databases › how to remove leading and trailing spaces in an entire column in excel google docs

Trimming Spaces in Excel & Google Sheets | Atlassian

The most obvious (and generally efficient) method for removing both leading and trailing space is to use the TRIM() function. As stated in the official documentation, TRIM() “removes all spaces from text except between words.” Unfortunately, ...

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.

GeeksforGeeks

geeksforgeeks.org › excel › how-to-remove-spaces-in-excel

How to Remove Spaces in Excel - GeeksforGeeks

April 29, 2024 - For example, if a cell contains " Excel", using the TRIM function (=TRIM(A1)) can remove the leading space, resulting in "Excel". 2. Trailing Spaces: Spaces after your text, like "Excel ". Again, the TRIM function can clean this up, leaving ...

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 - Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates. ... The TRIM function is a built-in function in Excel and is widely used by users. It is accurate and reliable in removing leading spaces before text and numbers.

MrExcel

mrexcel.com › forums › question forums › excel questions

Remove leading and trailing spaces keeping multiple spaces between words intact | MrExcel Message Board

October 10, 2022 - I notice the TRIM function removes multiple spaces between words . ... Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign). ... You could eventually use Power Query ? Remove excess spaces in Power Query - Excel Off The Grid ( your profile does not specify your Excel version)

Super User

superuser.com › questions › 727108 › get-rid-of-extra-space-in-cell-when-using-text-wrap

microsoft excel - Get rid of extra space in cell when using Text Wrap - Super User

Top answer

1 of 16

I was able to reproduce the behavior you are seeing (also in Excel 2007). I can't find a way to get rid of the extra space once it's there, but I found that if you reverse your steps and apply the Text Wrap in a cell prior to entering your text, you will not get the extra blank line.

2 of 16

I had the same problem just before I've typed this. And here is what I've found.

When you press wrap text the cells height is automatically adjusted. Also its height is not calculated as we expected. If there is very little space left on the last row of the text, Excel decides that the cell needs one more row... even if there is not a single letter on it.

If you get the cell's width a little wider, the automatic cell height adjustment removes the extra line.

Character Count Tool

charactercounttool.com

Character Count Tool - The Best Character Counter

This character counter software works in any web browsers such as Chrome, Firefox, Internet Explorer, Safari, Opera... It suits to count characters in twitter, blog, books, word document, excel document, pdf document, essays, novel...

Microsoft Support

support.microsoft.com › en-us › office › trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9

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.

reddit.com › r/excel › cannot remove invisible spaces between words

r/excel on Reddit: Cannot remove invisible spaces between words

June 20, 2025 -

I pulled table data from a pdf using Power Query. Everything looked good, but I noticed that when I sent it back to Excel there were double spaces in between the first, middle, and last names, but they are not normal spaces. I looked it up and they are unicode characters.

I thought they were non-breaking spaces, but using Replace.Values to find and replace #(00A0) didn't work. I set the column datatype to Text and I still got the same result. I added the special character options to find and replace (#(cr), #(lf), and #(tab)), but none of those worked, either. I tried to split the column using space as the delimiter, but I only returned a column of "null" values.

If I use Clean(), it works, but it crams everything together -- which is not what I want. I noticed that if I open the spreadsheet in Googlesheets, all of those spaces show as tiny square boxes, but I can't see them at all in Excel.

Outside of manually adjusting the spacing in each cell, is there an easier way to accomplish removing the invisible spaces?

Top answer

1 of 5

The easiest way would be to find out what that character is and substitute it. Can you paste the text into a website like this: https://checkserp.com/encode/unicode/

2 of 5

copy the characters from Google sheets then search replace (ctrl+h) double character for single space