support.apu.edu

Merging two Excel columns into One

If you have two columns of information that you would like to combine into one column example first name and last name being combined into Fullname

Screen_Shot_2013-11-08_at_10.21.43_AM.png

 

Excel provides a function called Concatenate:

Screen_Shot_2013-11-08_at_10.34.14_AM.png

 

Which produces the following result:

Screen_Shot_2013-11-08_at_10.35.01_AM.png

 

If you wanted the output to be Mouse, Mickey

Screen_Shot_2013-11-08_at_10.37.12_AM.png

 

Remember you can use the Autofill button to copy the function to your other cells. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Article is closed for comments.