Remove Extra Spaces In Excel

Use the substitute function to remove all spaces or non breaking spaces.

Remove extra spaces in excel. Select the cell or range of cells from which you want to remove white spaces. For removing all these extra spaces from cells the trim function can help. Control h to activate find and replace option.

There are multiple ways to remove spaces in excel. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. Select a cell next to the cell you want to remove extra spaces from string type this formula.

In the find what field type two spaces. Select the entire column you want to clean. Using the search and replace short cut key.

The excel trim function strips extra spaces from text leaving only a single space between words and no space characters at the start or end of the text. Keep pressing the replace all button until all extra. In find what input bar insert a blank space using the space bar and replace with should remain blank.

Remove spaces in excel. Press enter key to get the result then drag auto fill handle over the cells you want to remove extra spaces from all of leading spaces and trailing spaces and extra spaces have been removed. Remove extra spaces including leading trailing and excess in between spaces from cells supposing you have a column list of cells containing leading trailing and excess in between spaces.

In the replace with field type one space. The trim function in excel removes leading spaces extra spaces and trailing spaces. This removes the spaces anywhere from the selected cells.