Need to combine the values of two columns in a CSV file with or without spaces? Excel makes it easy using the CONCAT function.
Combine Two Columns with a Space
Use the following formula:
=CONCAT(A2, " ", B2)
This combines abc in column A and 123 in column B to produce abc 123 in column C, with a space between the values.
Combine Two Columns Without a Space
Use the following formula:
=CONCAT(A2,B2)
This combines the same values into abc123, with no spaces.
Apply the Formula to All Rows
After entering the formula in the first row, either drag the fill handle (the small square in the bottom-right corner of the cell) down the column, or simply double-click it to automatically copy the formula to all remaining rows.
#windows
0 Comments