COMBINE TEXT AND NUMBERS USING MICROSOFT EXCEL

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!".

COMBINE TEXT AND NUMBERS USING MICROSOFT EXCEL

Note: Each cell reference must be placed between & operators, and additional text must be surrounded by quotation marks.

Microsoft Excel 2007 Tutorials, Combine Text and Numbers Using Microsoft Excel, Concatenation Function in Excel, Microsoft Excel Video Tutorials, How to Use macros in Excel?