How to Find and Replace Space Strings in Excel 2007

1. Open your Excel spreadsheet in Microsoft Excel 2007.
2. Hold the 'Ctrl' key and press 'H' to open the 'Find and Replace' window.
3. Click the 'Find what' field and press the space bar to enter a space in the field.
4. Enter the replacement text in the 'Replace with' field. This is the text that appears in place of the spaces. If you prefer to simply remove the spaces, then leave this field blank.
5. Click 'Replace all' to automatically replace all spaces in your spreadsheet. Alternatively, click 'Find next' to locate each occurrence, one at a time, and click 'Replace' to selective replace the spaces.
6. Click 'Close' to close the Find and Replace window.