title: Concatenate two columns in Excel VB Macro to column in second spreadsheet
body: <p>I need to concatenate two columns in People.xls <code>Range("A2: A100")</code> and <code>("B2:B100")</code> to Places.xls <code>Range ("A2: A100")</code> using a VB Macro. I've tried recording a macro and copying and pasting the values from an additional column in <code>C3: C100</code> which contained the concatenate formula `=CONCATENATE(A2, " ", B2). But this doesn't see to work very well, and isn't very practical. Is there any way it can be done using VB in the macro itself? I've been playing around but I'm having no luck</p>