iYogi

Home » Latest, TechGenie Answers, Technology » How to Combine Columns of Data in MS Excel

How to Combine Columns of Data in MS Excel

MS excel is an electronic spreadsheet program created and developed by Microsoft. It is used to store, organize and manipulate data. An Excel screen contains greed of rows and columns. Horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C) and For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.

MS ExcelThere are many instances in which you may need to join columns of data into a single column. Here are simple steps which you can follow and comfortable combine Colums in MS Excel

Step 1:

You need to create a new column for the combined data. And then select a cell in that column. Next is to insert menu across the top of the screen and choose function.

Step 2:

After you see Function menu choose all for the Function category. In the function name box highlight any name and start typing CONCAT after highlighting the concatenate function click the OK button.

Step 3:

You can see the Concatenate Function Wizard appear. When you see that drag the Wizard out of your way so that you can see the columns of data. In the Text1 box you will be able to see the blinking cursor. Take your mouse cursor and select the first cell of data that you want to combine, that cell reference will automatically populate the Text 1 box.

Step 4:

Some time it happens that you don’t want to combine the data without a delimiter of some sort like a comma or even a space. If not done so the data will run together. So to avoid this in the Text1 box to the right of the cell reference type the & sign, then “, then the delimiter of your choice, and press the space key and “again.  This & sign lets Excel to know about the joining of the cell reference with text and text must be in quotation marks.

Step 5:

Then use your mouse to move the cursor to the Text2 box. Take the cursor and select the second cell of data that you want to combine. This new cell reference will automatically populate the Text2 box. Click on the OK button on the Concatenate Function Wizard to complete the formula and delete the original columns of data.

Step 6:

Now you need to copy and paste or you can even use the mouse to drag the function or formula and then combine the remaining cells. You have to copy and paste the values and delete the original columns of data.

Harmeet

About Harmeet


loves to simplify technology for all readers who are interested in the genre but find it complex to comprehend. She is a writer by passion and wants to enrich the life of others by writing about the latest gadgets, apps, and devices in the simplest and the most useful manner. Her blogs are detailed, interesting, and definitely fun to read…


Experience the Best Computer Support

Leave a comment

*