How use Word to Find and Replace a Random Number of Spaces with a Single Tab Character

Ever receive or download some file with data that's separated by spaces that you'd like to replace with tabs so you could convert to table but a standard find and replace wouldn't work because the number of spaces involved was different between items?

If so, change multiple spaces into a single tab by doing the following:

  1. Open Find And Replace dialog box.
  2. Hit the More button.
  3. In the Find What text box, enter a single space character by hitting your space bar once and then type following characters, exactly as shown: {2,}
  4. In the Replace With box, enter ^t.
  5. Check the Use Wildcards option. 
  6. Click Replace All and then Close.

Cool, huh?  Now your multiple spaces are single tabs, making conversion to table easy.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.