Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

How to Use the TEXT Function to format and combine text
Addicted To Cialis Medrol Packs Buying Viagra Over The Internet Bio Brite Sun Alarm Can Plavix Substitute For Coumadin Viagra And Affiliate Breast Augmentation Discussion Boards Natural Herb For Lasix Plavix And Inr Breast Enhancement Capsules Ultra Curves Estrogen Coral Calcium Supreme 240 Zelnorm Affects Birth Control Patti Labelle Clas Of The Choirs Benefit Of Coral Calcium Hgh Effects On Teens Buy Hgh Buy Hgh Buy Hgh Anoretic Cardura Medication Leukeran Pet Medication Levitra For Females Out Of Court Settlement For Viagra Prednisone Prescribing Lamictal Bipolar 1 Aleve Pregnancy Coumadin Anticoagulation Drug Interaction Cipro Zoloft And Sudafed Plavix And Aspirin Interactions Use Zovirax For Effective Herpes Treatment Medrol Dose Pack And Crohns Synthroid Hot Flashes Geodon Im Cialis Manufacturer Jewish Purim Cookies Squill And Lipitor Synthroid Destroys Thyroid Advil Or Motrin Atarax Prescribing Information Flonase For Kidney Stones Lotrisone Cr 30 Mg Cost Of Viagra In The Philippines Can I Take Prozac At Night Zoloft Cleft Palatte Benefit Of Coral Calcium 0a North Beach Pizza Soma San Francisco Viagra Over Counter Herb Valproic Depakote Hypothalmus Hoodia Tlc Lasix Veterinary Dose Of Tramadol Neurontin Use

Today, we will be using the TEXT Function to present our data in a user friendly format. For our example, we have our branch names in Column A, Yearly Revenues in Column B and the percentage of our stated aim that was met in Column C. Here is how we’ll use the TEXT Function to combine all these pieces of data in an easy to read fashion as well as format the text as well.

How to Use the TEXT Function to format and combine text

  1. Layout out your data like what we have done in our example or apply the concept to your own preferences.
  2. Select cells C2:C10 and type the formula =B2/1000. Press CTRL+Enter after typing the formula
  3. Select cells D2:D10 and type the following formula: =”Our “&A2&” branch made “&TEXT(B2,”$0.00″)&” in Yearly Revenue. That’s “&TEXT(C2,”0.0%”)&” of our yearly goal.”
  4. Press CTRL+Enter

How to Use the TEXT Function to format and combine text

You should now be set! This tip should work in Excel 97, 2000, 2003 and 2007.

How to Use the TEXT Function to format and combine text
  1. Combine Cells with text, date, time and numbers in Excel
  2. How to Use a custom format to create a time format
  3. How to Use the TIME function to combine single time parts
  4. How to Combine Parts of Date using the DATE Function in Excel
  5. How to Use the COUNTA function to count cells containing text

Article Information

Category
Formula and Function Examples

Tags
, ,

Trackback URI

Comments RSS


Leave a Reply

← Customize the Excel 2007 Quick Access Toolbar
How to Use the SUBTOTAL function to sum a filtered list in Excel →