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