The Microsoft Office Excel spreadsheet editor is designed to work with relatively small data sets that do not have to contain only numerical values. Words, phrases and even text fragments can be placed in the cells of spreadsheets. To process data of this kind, as well as for numeric cells, formulas are also used. In particular, the spreadsheet editor has functions for combining (summing) several text cells.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
Start Excel and load the desired table into it. Select the cell where you want to place the merged text.
Step 2
Go to the "Insert" tab in the program menu and open the drop-down list labeled "Text" - it is placed in the "Function Library" command group. The list contains more than two dozen operations for working with text variables, sorted in alphabetical order - scroll down to the lines starting with the letter "C" and select the "CONCATENATE" function. This will launch the New Function Wizard dialog box, in which you will need to fill in several form fields.
Step 3
Specify the address of the cell containing the text with which the line should begin in the table cell being created. It must either be entered manually in the "Text1" field, or by clicking the required cell of the table with the mouse cursor. Then repeat the same action for the "Text2" field - here you need to place the address of the cell with the text that should be added to the previous one. When you move on to filling in the second field, Excel will add a third just in case - you can use it if you need to construct a value from three or more original cells. A new line will be added constantly as the previous ones are filled.
Step 4
Note that the function will concatenate text values as they are, without adding anything as a separator. If you need to insert a space, a comma or any word between them, then use a line in the form of the wizard for creating a formula - enter the necessary characters into it, enclosing them in quotation marks. For example, if you specify a link to the first cell in the "Text1" field, enter "," in the "Text2" field, and a link to the second cell in "Text3", then a comma and a space will be placed between the labels.
Step 5
Click OK and the cell will display a value containing the combined text of the cells you specified.
Step 6
The Function Design Wizard can be called without going to the Formulas tab. To do this, just click on the formula insert icon located above the table to the left of the formula bar. Then select the line "Text" in the drop-down list "Category" and in the field "Select a function" find "concatenate". By clicking OK you will open a window with the form described above.
