Insering newline at every space

I have a text file with data arranged in the following order:

Name Address Name Address Name Address ... so on

I want to arrange it like:

Name
Address
Name
Address
Name
Address
.
.
.
so on

How can I achieve this using VBA??
I figured out that at every space, if I insert a new line than it will be solved.. but no idea how to do that??

So my program is required to check a text file and insert a newline at every space it finds


Regards

post a sample file...

Originally Posted by Rem0ram

post a sample file...

sample file is attached

Data.txt

Does this help?

Please Login or Register  to view this content.

assumes original data is on row 2.

Maybe:

Please Login or Register  to view this content.

Assumes original data is on row 2 of a spreadsheet.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Assumes original data is on row 2 of a spreadsheet.

Thank you It works

but it needs to be done in the "text file". When the program runs it would open the text file and do necessary changes and save the file.
Maybe I'm asking too much :P
but thanks for the code