Simple trick to replace multiple spaces with single tab character

Category: Tricks n TechniquesTags: ,

If you have data with multiple space characters and you wish you could replace all the multiple spaces with tab characters (I bet you want to paste it into Excel), here is a quick trick – Use RegEx in Notepad++.

  • If you don’t have Notepad++, download and install it.
  • Open the Notepad++ and paste the text into new document
  • Go to Search menu > Replace… (Shortcut Ctrl+R)
  • Paste or type "([ ]+)" (without quotes) in “Find what…” box
  • Paste or type "\t" (without quotes) in “Replace with…” box
  • Select “Regular expression” in “Search Mode” section.
    Notepad++ replace multiple spaces with tab character
  • Click “Find Next” button to make sure that it find the right text
  • Click “Replace” to make sure that it replaces it correctly. Use it multiple times before you click “Replace All”.
  • Once done, set the “Search Mode” to “Normal” again

Regex Explanation

Here is what Regex does in layman’s terms.

([ ]+)

Bracket () represents regex group

Square brackets [] represent individual characters within it to search for. Note that there is a space character in between [ and ].

+ represents 1 or more characters.

So it says to find a 1 or sequence of multiple consecutive space characters

\t

\t represents a single tab character

Share

2 comments

Your email address will not be published. Required fields are marked *

  1. ganesh says:

    Thank you chad.. ([ ]{2,}) worked for me..

  2. Chad Schultz says:

    Based on the title of multiple spaces; the regex should be ([ ]{2,})