13. Combine text and numbers
In this example, we want to combine text and numbers. Use the & operator to accomplish this.
To combine cells containing text and numbers:
1. Select cell B1 and type computers.
2. Select cell B2 and type 5.
3. Select cell B4 and type the following formula: ="You ordered " & B2 & " " & B1 & " today!".
Note: Each cell reference must be placed between & operators, and additional text must be surrounded by quotation marks.
Hope You Like This Tutorial - Give Comments
