Microsoft Office Tutorials and References
In Depth Information
Joining Text and a Number
Caution
When you enter the formula in Figure 9.7 , you must hold down the
Shift key to enter the quotation marks in “ ” . Many Excel users
accidentally hold down the Shift key while pressing the spacebar.
However, Shift+Spacebar is the Excel shortcut for selecting an entire
row. If your formula changes to =A2&"A:A because you pressed
Shift+Spacebar, you can press the Esc key and start over.
Joining Text and a Number
Joining Text and a Number
In many cases, you can use the & operator to join text with a number. In Figure
9.8 , the formula in cell E2 joins the words The price is $ with the res-
ult of the calculation in cell D2. Because cell B2 contains an integer with no
special formatting, the answer appears correctly.
Figure 9.8.
Figure 9.8. Joining text with a number works if the number is formatted with
Joining text with a number works if the number is formatted with
general formatting.
general formatting.
In Figure 9.9 , cell D2 is formatted to display a currency symbol and two
decimal places. When you join this value to text in cell E2, Excel ignores the
formatting in cell D2 and shows the result with all the decimal places. A
similar problem exists when you want to join text with a date. Excel ignores
the fact that the text in cell D4 is formatted as a date and shows the under-
lying value in cell E4.
Search JabSto ::




Custom Search