Remove Extra Spaces In Excel

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.

Remove extra spaces in excel. In find what input bar insert a blank space using the space bar and replace with should remain blank. There are multiple ways to remove spaces in excel. Excel substitute function the excel substitute function replaces text in a given string by matching. Keep pressing the replace all button until all extra.

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

Use the shortcut key. Select the entire column you want to clean. The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. There we need to put a space and replace that with blank nothing kept.

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. Select the cell or range of cells from which you want to remove white spaces. The trim function below removes 2 leading spaces 3 extra spaces and 2 trailing spaces. Press the ctrl h shortcut to open excel s search and replace window.

In the find what field type two spaces. Using the search and replace short cut key. Remove spaces in excel. Use the substitute function to remove all spaces or non breaking spaces.