Question

1) to use text formulas in MS-Excel worksheet.​

Answer 1

Answer:

Select the cell where you want to show the combined data

Type an = to start the formula

Click on the cell that contains the first text for the combined string

Type the & operator

Click on the cell that contains the next text for the combined string

Press Enter to complete the formula