This wikiHow teaches you how to remove unwanted spaces from cells in an Excel spreadsheet. Highlight the range in which you want to remove all spaces. For example, if you want to remove spaces from C2 through C30, highlight those cells.
Using Find and Replace
Highlight the range in which you want to remove all spaces. For example, if you want to remove spaces from C2 through C30, highlight those cells.
Click the Edit menu.
Select Find.
Select Replace…. A dialog box will appear.
Click the box beneath 'Find What.'
Press the space bar on the keyboard. Make sure to press it only once.
Click Replace All. It's the second button at the bottom of the window. The spaces are now removed from the selected cells. A pop-up will appear, letting you know how many spaces were removed.
Click Click OK.
Using the Substitute Function
Type =Substitute.[1]
Type , (a comma). The cell should now look like this: =Substitute(C2,.
Click the cell with the formula you typed. The cell should now be highlighted.
Drag the fill handle down over the cells you want to fill. The data from each corresponding cell will now appear in your new column without spaces.
Copy the data from the new column to the original column. Your new space-free data is now in place.
Update 08 June 2020
ncG1vNJzZmismaXArq3KnmWcp51ktbDDjK2mZqqVory3sYysp5qblah6o7HTsJyepl2YtaK%2BwJyrnqqjYq6vsIynrKaalafAbrXNZpyxm5Wh