Learn How To Merge Two Columns In Excel Into A Single One.

Asked By 30 points N/A Posted on -
qa-featured

Hi. I have started working for a company. I don’t have much knowledge about Excel; I need to merge two columns in Excel into a single one. Please reply ASAP. Thanks!

Image result for merge two columns in Excel
SHARE
Answered By 50 points N/A #294776

Learn How To Merge Two Columns In Excel Into A Single One.

qa-featured

Hi. It’s very easy to merge two columns in Excel into a single one, or you can add more than two columns also.To combine two columns, for example, you have to combine a name of the person. Click on the cell on which you want to put the merged text.Type =(, now click on the cell that contains the first column you want to merge, and type &” “&. Now, click on the next column and select the text you want to combine.Type ) and then enter.To merge the text from more cells, continue selecting the cells, and type &” “& after each cell.If the user need to add a comma in the text type &”,”&.

OR

Image result for merge two columns in Excel

The other way is to use the merge cell option.

Login/Register to Answer

Related Questions