Get Rid Of Spaces In Excel

Control h to activate find and replace option.

Get rid of spaces in excel. C2 in the column that isn t the title. In the find what field type two spaces. The trim function does.

The first way we can remove the extra unwanted spaces with the help of find and replace option ctrl h. Press the ctrl h shortcut to open excel s search and replace window. Choose one or more options.

In the find what box enter two spaces. Press enter key to get the result then. Press ctrl h to display the replace tab of the find and replace dialog box.

Remove leading and trailing spaces trim. Make sure the replace with box is empty. And now whenever you want to remove blank spaces in your excel sheets perform these 4 quick steps.

Press ctrl h to open the find replace dialog box. Remove all extra spaces from strings with the trim function 2 steps. Press space bar in the find what field and make sure the replace with field is empty.

For example to remove a non breaking space you can use. Select the match entire cell contents check box. Use the shortcut key.