Forum Discussion
DebraNorman7518
May 29, 2023Copper Contributor
How to Combine two cells in Excel
How do I combine these two columns into one column Alex August WAL-MART #3542, HOUSTON, TX
mathetes
May 29, 2023Silver Contributor
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.