Combining Text and Values in one cell

Text and values in one cell

How can you combine text and values in a single cell?

For example, lets say cell A1 contains the value 1977.

Enter the following formula into another cell:

=”Total: “&A1

The formula cell will display: “Total: 1977.”

The ampersand is a concatenation operator that joins the text with the contents of cell A1.

Applying a number format to the cell containing the formula has no effect, because the cell contains text, not a value. As a work-around, modify the formula to use the TEXT function (the second argument for the TEXT function consists of a standard Excel number-format string).

=”Total: “&TEXT(A1,”$#,##0.00″)

This formula will display “Total: $1,977.00.”

Here’s another example formula that uses the NOW function to display some text along with the current date and time:

=”Report printed on “&TEXT(NOW(),”mmmm d, yyyy at h:mm AM/PM”)

Related posts:

1. Converting Time Zone Values
2. How to increase cell phone battery Life?
3. The most expensive cell phone in the world
4. Download Games for Cell Phones for free.
5. Call International from your cell for free.
6. Update Charts Automatically
7. Useful Tips in Excel
8. Moving Between Precedent and Dependent Cells
9. Calculate Years, Months, Days elapsed
10. Create, Edit, Annotate, Manage and Display XPS, XAML, RTF Text Document with Danet Studio