Forum Discussion
How to Combine two cells in Excel
How do I combine these two columns into one column Alex August WAL-MART #3542, HOUSTON, TX
Let's say the cells are A2 and B2.
If you want the two text strings side by side, for example with a comma and space in between:
=A2&", "&B2
If you want the combined text in two lines in a cell:
=A2&CHAR(10)&B2
Turn on Wrap Text for the cell(s) with the latter formula.