How to remove Space in Excel Col
Using Find & Replace to remove extra spaces between words
This option needs fewer steps, but allows only deleting excess spaces between words. Leading and trailing spaces will also be trimmed to 1, but will not be removed.
Select one or several columns with the data to delete spaces between words.
Press Ctrl + H to get the "Find and Replace" dialog box.
Press the Space bar twice in the Find What field and once in Replace With
Click on the "Replace all" button, and then press Ok to close Excel confirmation dialog.

Subsection: IT Knowledge
Section: Student Zone

Topic Files

Last edited REHAN - 11 Oct 2021, 12:15
Latest Activity: 11 Oct 2021, 12:15