
() Regex to Replace X or More But Less Than or Equal to Y Spaces with Tab Character If you have a need to replace exactly 2 spaces, use following regex for “Find what” box. \t represents a single tab character Regex to Replace Exactly 2 Spaces with Tab Character So it says to find a 1 or sequence of multiple consecutive space characters Note that there is a space character in between.

Square brackets represent individual characters within it to search for. Here is what Regex does in layman’s terms.

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

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++.
