How to prepare data in Microsoft Excel
How to remove redundant spaces from imported data in Microsoft excel:
- Select the cell (range) affected
- Select Start
- Select Edit > Replace
- Enter a space in the search field
- Leave the replace field empty
- Select Replace All
-
1. Select the cell (range) affected
-
2. Select Start
-
3. Select Edit > Replace
-
4. Enter a space in the search field
-
5. Leave the replace field empty
-
6. Select Replace All