Let's say you have a spreadsheet containing first names in column A and last names in column B. And you want to create a new column combining the first name and last name. The formula to use is =CONCATENATE(A1," ",B1). Be sure to add a space between the two quote marks.
How to combine two columns in Excel into one column
Subscribe to:
Post Comments (Atom)
2 comments:
Very useful thank you.
Hi,
Yup...right here in the manual just as you explained, but...never would have found it without your great website to help me find it in the index. A+A+A+ Thank you, Roy
Post a Comment