WHAT DOES A TELECOMMUNICATIONS ENGINEER DO? Telecommunications engineers design, build and manage systems that carry out the transmission, processing and storage of information as electrical or optical signals. A wide range of technologies are involved in any telecommunication system.
Combine Text from Multiple Cells. To combine text from multiple cells into one cell, use the & (ampersand) operator. 1  Select the cell in which you want the combined data. 2  Type an = (equal sign) to start the formula. 3  Click on the first cell. 4  Type the & operator (shift + 7). 5  Click on the second cell. 6  Press Enter to complete the formula.
On the Home tab, in the Alignment group, click Merge and Center. The cells will be merged in a row or column, and the cell contents will be centered in the merged cell. To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells. Note: If the Merge and Center button is unavailable, the selected cells might be in Edit mode, or the cells might be inside an Excel table. To cancel Edit mode, press ENTER. You cannot merge cells that are inside an Excel table. To change the text alignment in the merged cell, select the cell, and then click any of the alignment buttons in the Alignment group on the Home tab. Note: Formula references in other cells are adjusted automatically to use the cell reference of the merged cell.