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).
Hope You Enjoy this Tutorial - Give Comments
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.
ReplyDeletedigital certificate