Microsoft Office Tutorials and References
In Depth Information
Excel also has a CONCATENATE function, which takes up to 255 arguments. This func-
tion simply combines the arguments into a single string. You can use this function if
you like, but using the & operator is usually simpler and results in shorter formulas.
In some cases, the Flash Fill feature (introduced in Excel 2013) can substitute for creat-
ing formulas that concatenate text. See Chapter 16 for more information.
Displaying formatted values as text
The Excel TEXT function enables you to display a value in a specific number format. Although this function
may appear to have dubious value, it does serve some useful purposes, as the examples in this section demon-
strate. Figure 5-3 shows a simple worksheet. The formula in cell D5 is
=”The net profit is “ & B3
Figure 5-3: The formula in cell D5 doesn't display the formatted number.
This formula essentially combines a text string with the contents of cell B3 and displays the result. Note,
however, that the value from cell B3 is not formatted in any way. You might want to display B3's contents using
a currency number format.
Contrary to what you might expect, applying a number format to the cell that contains
the formula has no effect. This is because the formula returns a string, not a value.