Title: 4 Ways to Remove Unwanted Space Characters | How To Excel
Headings: 4 Ways to Remove Unwanted Space Characters
4 Ways to Remove Unwanted Space Characters
Table of Contents
Our Example Data for the Post
Removing Extra Spaces with the TRIM Function
Removing Extra Spaces Between Words with Find and Replace
Removing Extra Spaces with Power Query
Removing Extra Spaces Between Words With VBA
Conclusions
Subscribe
Consulting
Excel Insights
Excel Functions eBook
Microsoft MVP
Categories
Advertisement

Content: 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! “. TRIM (B2) would return the contents of cell B2 with extra spaces removed. TRIM (" Hello World! ") would return “ Hello World! “. Removing Extra Spaces Between Words with Find and Replace
The next method will use Excel’s find and replace search feature. This will only work for removing extra spaces between words. First, we need to select the rage of cells to which we want to remove extra space. Then go to the Home tab ➜ Editing section ➜ press the Find & Select button ➜ choose the Replace option from the menu.