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 |
Assuming those two cells are A1 and B1, here are two different formulas, with slightly different results.
Now that I've answered the question, though, may I question your question? In general, it is better practice to keep discrete cells discrete. It's always easy to put them together for temporary, short-term purposes when they're kept discrete; it's more difficult to take them apart if you've put them together and kept them as a "unified cell"......
And if Alex is a first name and August a last name, even those would be better kept as two separate fields. That way you can easily assemble "Alex August" for one purpose and "August, Alex" for another.
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.
