Fresh Excel Tips

Quick and Easy Excel Tips and Tutorials

Using the SUBSTITUTE function to substitute parts of a cell
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

Previously, we had used the SUBSTITUTE function to replace characters in a cell, you can view that tutorial HERE. Today, we’ll be using this function to replace “-” with a blank space, not only that but we want only the first occurrence of it to be replaced. For example, we have 333-444-555, the value we want returned is 333444-555. Here is how we will achieve this. This should work in Excel 97, 2000, 2003 and 2007

How to substitute parts of a cell in Excel

  1. Enter your values in Column A1, for example, 123-456-7890
  2. Select cells B1:B10 and type the following formula: =SUBSTITUTE(A1,”-”,”",1).
  3. Press CTRL+Enter.
  4. If you want to substitute the second occurrence of this character, use the following formula: =SUBSTITUTE(A1,”-”,”",2)

Tell us what you think.

Using the SUBSTITUTE function to substitute parts of a cell
  1. Using the SUBSTITUTE function to substitute characters in Excel
  2. How to Extract digits from a cell using the MID Function in Excel
  3. How to Separate Cell Values Using the Trim Function in Excel
  4. How to use the TEXT function to extract parts of a date in Excel
  5. Use the LEFT, MID, and RIGHT functions to extract date parts

Article Information

Category
Formula and Function Examples

Tags
,

Trackback URI

Comments RSS


Leave a Reply

← How to use the WORKDAY function to calculate workdays in Excel
Use the ISEVEN and ISODD functions to check if a number is even or odd →