Excel is a spreadsheet program that comprises the Microsoft Office suite, a very versatile and ideal tool for financial tasks and what this refers to. In them you can perform various mathematical operations such as adding, multiplying, dividing and subtracting. This type of table design is composed of rows, columns and cells, each of the latter is the intersection of the other two. They can contain text, numbers, or a formula that uses existing values in others. In particular, they are very practical as it not only helps with those procedures, but also facilitates the fact of drawing graphs, generating databases, budgets, among other things.
If you want to keep track of your finances, or if you are a merchant and you are starting your business, Excel is a good idea to take out the accounts or generate your inventories, because it contains a kind of boxes where each one will allow you to keep an order in the information you enter. Many times when carrying out these works, the need arises to combine several columns with each other, fortunately you can do it without mishap with the function named “concatenate” and other methods, which are precisely to unify the contents for a better visualization.
If you do not know how to merge in excelIn this article we will explain step by step what you should do so that your document is in order and how you want it without losing anything.
Steps to combine cells in Excel without losing information
If you are working on a task in this program and you want to improve the appearance of your book and columns, You can apply a combination of cells to have a better understanding and interpretation of the information.
To run this, you just have to perform the steps as shown below. In case you lose any writing in the process, you just have to press “Ctrl + Z”And you can reestablish.
From the toolbar
With the Excel tools option, you can merge cells to create a larger one. This in case you want to establish a label that covers several columns at the same time, as shown in the example below:
To do this you must do the following:
- You will click on the first cell and you will select the rest as far as you want the label you are creating to go.
- You will then click on the Excel bar, followed by “Start” and you will look where it says “Merge and center”. Pressing there will automatically join the cells.
- If you change your mind you can still undo everything you did either in the same option of “Merge and center” or with the keys “Ctrl + Z.
- IMPORTANT: Verify that only one of the cells has information, because otherwise you will lose the rest. Since you are in this case combining to create a header.
From the keyboard
If you want to speed up this process by a shortcut, We tell you that you can do it from the keyboard as follows, you just have to follow the respective commands:
- Select cells that you want to merge.
- Then press on the keyboard “Alt” to access the options bar. You will notice that each section will be assigned a letter. To access these you just have to press the corresponding one.
- In this case you will choose the “letter O”, since the command you want is in the tab “Start”.
- The combination is assigned to the M2 key, for this you must press on your keyboard the letter M followed by number 2 to activate the menu.
- When it opens you will see that each option has another letter set. To run the command “Merge and center”, you just have to press the “C”.
- In this way you will already have your columns merged.
From the toolbar through the column configuration
Another way to access this configuration is through the toolbar that gathers most of the commands of the program. To run it do the following:
- Select cells that you want to put together.
- In the menu “Start” you will look for the section that says “Format” followed by “Cell section”.
- A configuration box will open immediately, where you must search and enter the section of “Alignment”.
- In the text control part you are going to select “Wrap text” “Merge cells” and accept.
- Thus the chosen cells will be unified and you can make a header or an information box, according to what you want to do.
How to combine text from two or more cells into a single cell in Excel?
If you need the text to be complete and that it is not separated by the columns, With these simple steps based on formulas, you can unify names and figures so that you have a fully legible document without divisions.
- The first thing you have to do is select cell where you want to put the combined data.
- In the column you chose you will write the following formula = CONCATENATE (.
- You must use the letter and number of cells to choose them or click each one with the mouse to identify the ones you want to unify.
- As you select them, you will place (;) between each of them like this: = CONCATENATE (A1; etc …
- When you have finished choosing the cells, you close the parentheses and the formula should look something like this: = CONCATENATE (A1, B1, C1, D1) depending on the amount you want.
- Once this is done, it will only remain to touch “Enter” and your cells will be merged into one.
Formula with &
- You should also choose cells where you want the result to be.
- In which you chose so that all the others are united, you are going to write the following formula “=” and choose the first cell you want to unify, that is, = C1 & “
- Select the other cell and give it in “Enter”, example, “& D1
- So on, in this case depending on the quantity the final formula would be: = C1 & “” & D1 & “” & E1 & “” & F1.
- Now you just have to touch the key “Enter ” and ready.
With this same formula you can also In addition to unifying the cells, add a text. To do this, you must add some writing between the quotes, something similar to this: = C1 & “Name” & D1 & “” & E1 & “” & F1
These steps can be done from the same column or from the toolbar “Insert function” (Fx) which acts as the Excel assistant for functions that have to do with formulas.
If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will be of great help to more members of the community. Thank you! 😉