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.
Step 2: Identify the columns of data that you want to combine. For example, I want to combine columns A and B in the image below. Step 3: Click inside an empty column where you want the combined data to be displayed. Step 4: Type =CONCATENATE(XX, YY) into the first cell where you want to display combined column data. In the example below, I am combining data from cells A2 and B2. Step 5: Click the cell you just created, then press Ctrl + C to copy it. Step 6: Select the rest of the column below the cell you just created, then press Ctrl + V to paste the copied data into these cells.