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.