Pages

Tuesday, April 12, 2011

Use the SUBSTITUTE function to substitute parts of a cell - Text Functions - Microsoft Excel Tutorials


In this example, the “-” character needs to be replaced with a blank space. But only the first occurrence of this character should be replaced. To do this, type any kind of text and numbers in column A as shown in the screenshot below, using the “-” character in different positions and in a variety of occurrences.

To substitute parts of a cell:

1. Select cells B2:B10 and type the following formula: =SUBSTITUTE(A2,"-","",1).
2. Press <-Ctrl+Enter->.




Note: If you want to substitute the second occurrence of this character, use the following formula: =SUBSTITUTE(A2,"-","",2).

Watch the Video Tutorial - https://www.youtube.com/watch?v=jxYN3m2PLE4

 
Hope You Enjoy this Tutorial - Give Comments

1 comment:

  1. This post is very well written. I am aware of how to use SUBSTITUTE function to convert numbers to word but using the same function for substituting part of cell is new thing for us. I think I am going to try this out.
    digital certificate

    ReplyDelete

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews