Parsing text with VBA

I'm looking to write a macro that can take text from one cell and set a user defined number of spaces between it along with the text from another cell. I did it manually and used the macro recorder, but it doesn't really help
ie

Sub Parse_Text()
'
' Parse_Text Macro
'

'
    Range("E4").Select
    ActiveCell.FormulaR1C1 = "=RC1&""        ""&RC2"
    Range("E5").Select
End Sub

As I want to be able to tell the macro how many spaces I want between the text.
Eventually I will write the parsed text to a text file.

Is there a way to do this with VBA? Can someone just point me in the right direction?