same 2 possibility

If you want to use the macro change " - " by " " in the line Cells(intRow, 1) = Cells(intRow, 1) & " - " & Cells(intRow, 2
if not, use the excel function

=concatenate(A1," ",B1," ",C1," ",D1) in E1 for exempl