How to prepare data in Microsoft Excel

From Tygron Support wiki
Revision as of 09:26, 27 September 2019 by Vincent@tygron.nl (talk | contribs) (Created page with " {{Editor steps|title=remove redundant spaces from imported data in Microsoft excel|Select the cell (range) affected|Select Start|Select Edit > Replace|Enter a space in the se...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
How to remove redundant spaces from imported data in Microsoft excel:
  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