How to Combine Two Columns in a CSV File Using Excel (With or Without Spaces)

Need to combine the values of two columns in a csv file with or without spaces? Here's how to achieve that with Excel.

To combine with a space simply use the following 

=CONCAT(A2, " ",B2)

This will combine 'abc' in column A and '123' in column B and output the result 'abc 123' on column C with a space in between.

To combine two columns with no space, use the following:

=CONCAT(A2,B2)

Now your result in Column C would be 'abc123' with no spaces.

To apply this to all rows, enter the formula in the first row, select the cell containing the formula and drag the small square in the bottom-right corner of the cell or double click on it to auto fill the function to all rows.