If you’re working on large spreadsheets in Microsoft Excel, there might come a time when you have to decide to shorten the length of the spreadsheet without harming precious data. What you can do is to combine multiple cells into a single cell. In order to do that properly, you need to make use of the concatenate function. The word is just a fancy word on saying “to combine,” or to “join together.” To start learning how to use the function so that you can join multiple cells into one, then read on.
Using the Concatenate Command in Microsoft Excel
Step 1 – To start on using the concatenate command, first open the Microsoft Excel file you want to work on. Now select the first cell that you want to be combined, or in this case concatenated. Start by typing the function in as you type in “=CONCATENATE” without the quotes. So if you want to combine the first two columns, you would have to write something like this: =CONCATENATE (A1, B1).
Step 2 – Going back to the previous example, should A1 contain “First Name” and B1 contain “Last Name,” the Excel cell with the concatenate formula will then show up as “First NameLast Name.” So what if you want to add a space in between? Your formula should look something like this: “=CONCATENATE (A1, “ “, B1). Adding the space in between will therefore add a space between the texts, so the final output should look something like this: “First Name Last Name.”
Step 3 – To add more cells into the formula, just follow the previous steps and just add more cells from there. Therefore, your formula should look something like this: “=CONCATENATE (A1, B1, C1, D1).” Remember to press the Enter key on your keyboard whenever you’re done inputting all the cells into the cell with the formula.
Step 4 – Now, just copy the formula throughout other cells within the Microsoft Excel spreadsheet. All you have to do is hover your mouse onto the little cross mark located at the lower right portion of the cell you’ve currently selected. Your mouse pointer should transform into a cross. Once it does, click and drag it either downwards, upwards, towards the left, or to the right. Don’t worry as the application will calculate all the changes necessary for the formula so that you don’t have to edit each individual cell afterwards. Using this formula will save you a whole lot of time, and perhaps even a whole lot of headaches.
Share This on Facebook