How to insert a line break every five rows in Excel/Word/Notepad++?

excel, newline, notepad++, regex, replace

Solution

Using Notepad++ find/replace in regex mode:

Find: ((.*\s*\n\s*){5})

Replace: $1\n

Cheers.

Problem

I have this list: 08:17 17:01 08:09 16:56 09:22 17:01 08:08 17:05 07:59 16:54 . . . How do I insert a linebreak each 5 rows In Excel/Word/Notepad? (not < br >) For example: 08:17 17:01 08:09 16:56 09:22 (line break here) 08:08 17:05 07:59 16:54 08:02 (line break here) etc etc I've tried the /n/r/n/r but can't figure it out, do I have to use code or is there a tool like TextFX/Notepad++ or anything that has this feature?

Original source