Add and replace in notepad

[Andy Gregory]

Im trying to re-format a very large data set so that i can make use of it. THe data is set out something like this:

-1222 -1293 -1283 -8937 -2839 -2840 -3243

and i need it to be like this.

-1222
-1293
-1283
-8937
-2839
-2840
-3243

Yes, i could do this manually but with about 65,000 entries this will take to long.
I was hopeing to use the find & replace function to find all the gaps and replace them with [ENTER], but this i can not do. Does anybody know how to do this or of any other way of re-formatting data like this.

Cheers,

Andy,

 

[Tushar Mehta]

In MS Word, you can use ^p as an indicator for 'new line' So,
repeatedly replace two spaces by one space until Word indicates that no
replacements were made. Then, replace one space by ^p

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions