Combine Text and Numbers - Formulas In Excel - Microsoft Excel Tutorials

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.

Watch the Video Tutorial - https://www.youtube.com/watch?v=mhdI-_55tro

 

Hope You Like This Tutorial - Give Comments