How To Combine Two Columns In Excel?

Select the cell where you want the combined result

Use `=A2&B2` to combine columns A and B without a separator

Use `=A2&” “&B2` to combine with a space separator

Use `=A2&”,”&B2` to combine with a comma separator

Use `=TEXT(A2,”0″)&B2` if you need to format numeric values before combining

Use `=A2&”-“&B2` to combine with a hyphen separator

Enter the formula, then drag the fill handle down to apply to other rows

To combine with a line break: `=A2&CHAR(10)&B2` (then enable Wrap Text)