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
This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.
Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.
- Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
- Large color screenshots illustrate the instructions so following along is easy!
- Email notification of each new exclusive post for subscribers!
- Exclusive discounts on Office books and other products!