Microsoft Office Tutorials and References
In Depth Information
Showing Text and a Value in a Cell
Showing Text and a Value in a Cell
If you need to display a number and text in a single cell, Excel provides three options:
h Concatenation
h The TEXT function
h A custom number format
Assume that cell A1 contains a value, and in a cell somewhere else in your worksheet you want to
display the word Total: along with that value. It looks something like this:
Total: 594.34
You could, of course, put the word Total in the cell to the left. This section describes the three
methods for accomplishing this task using a single cell.
Using concatenation
The following formula concatenates the text Total: with the value in cell A1:
=”Total: “&A1
This solution is the simplest, but it has a problem. The result of the formula is text so that cell
cannot be used in a numeric formula.
Using the TEXT function
Another solution uses the TEXT function, which displays a value by using a specified number
=TEXT(A1,”””Total: “”0.00”)
The second argument for the TEXT function is a number format string — the same type of string
that you use when you create a custom number format. Besides being a bit unwieldy (because of
the extra quotation marks), this formula suffers from the same problem mentioned in the
previous section: The result is not numeric.
Search JabSto ::

Custom Search