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.
1 Open Calc or Excel. 2  Highlight the merged cell you want to split. 3  A merged cell will expand into multiple columns or rows. 4  Click the Merge cells button in the formatting bar. 5  Below is an example of what this button looks like in each of the versions of Excel and Calc that support this option.erge two cells using a formula. In Excel, you can merge two cells using a formula. Using the ampersand (&) in a formula acts to combine two cells or a cell and other text together. In this example, the formula =A1&B1 combines the values in cells A1 and B1 into cell C1.