![]() In this example we are going to do the same thing as in the example above, but we are going to use different data. Using CONCAT or CONCATENATE to merge columns in Excel Remember to hold Ctrl + Shift + Enter to make an array formula, with older versions of Excel. ![]() If you do this, curly brackets will appear before and after your formula, like this: (Legacy / CSE Version) The full formula will look like this: =A3:A12&B3:B12 (If you are using an older version of Excel, you will need to hold "Ctrl" and "Shift" on the keyboard before pressing "Enter". Type the address of the other column that you want to combine with, such as B3:B12.Type an equals sign and then a column reference, such as =A3:A12 to specify the first column to combine. ![]() To combine columns horizontally in Excel, follow these steps:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |