Concatenate to a text file

I have a function that does some calculations but it keeps putting data on a newline. I wanna concatenate data to the same line on a text file using vba. How do I achieve that?
For example:
I get this:
0
1
2
3
4
But I want:
0 1 2 3 4

You might want to post your other function to show how you are
accomplishing your first results.

Do you want your results to be all in one cell or separated out into
columns (i.e. 0 in column A, 1 in column B, 2 in column C, ...)