In many cases you can use the Ampersand symbol (& – what most folks call the “and” sign) operator to join text with a number in your formula.
- If you want to combine text with the results of a formula in a cell you use Concatenation.
- Suppose you have calculated a range of cells using a formula in cell D2. Now, you would like cell A2 display the text, Monthly sales are $21,000.00 ($21,000.00 is the value calculated in cell D2). As the value in D2 changes, you would like the value in A2 to update automatically.
- To achieve this, you would enter the formula below in A2:
- =”Today’s sales are $”&D2
The secret is using the Ampersand (&) to concatenate (join) text and numbers together. The Ampersand symbol acts as a plus sign (+) to join text strings together as one.
I bet you are going to be using this little beauty a lot now aren’t you?