Excel formula to remove space between words in a cell

Question

I've a huge data in excel file.

For eg: say i've a word like paul son,i've to make it as paulson.

input:paul son output:paulson.

In some cells ,i've data like mic-li,when this type of words come,it should not replace any thing,it should only remove spaces in between words.

Answer 1

There are three fast techniques to get rid of unnecessary spaces between words or remove all spaces from Excel cells. To clean up the content of cells, you can use the trim formula, Excel Find & Replace, or a special Excel add-in.

When you paste data from an external source (plain text reports, numbers from web sites, etc.) into an Excel spreadsheet, you're likely to acquire additional spaces in addition to vital data. Leading and trailing spaces, multiple blanks between sentences, and thousand separators for numbers are all possible.

As a result, your table appears disorganised and is difficult to utilise. It may be difficult to locate a client in the Name column since you are looking for "John Doe," which has no extra spaces between the names, yet your table reads "John Doe." Alternatively, if numbers can't be added up, extra blanks are to fault.