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
