Use the SUBSTITUTE and REPLACE functions

- [Instructor] Excel has two text functions … that are similar in nature … and yet different the way we use them. … Substitute and replace. … There's some code numbers in cell A3, A4, A5. … The substitute function allows us to replace information … based on content … whereas replace, based on position. … Let me zoom in here with control of the mouse wheel … so we can see this more prominently. … I want to remove all the dashes here, … In other words, I want to replace the dashes with nothing. … We have the option of replacing just the first dash … or second or third. … We see some other examples. … Every time we see the red texts here, … it indicates the kind of thing … that we might want to use this function for. … Equal substitute, … as soon as you see it in the list there … you can double click or tap it into place. … We're looking at this text right here in cell A3, comma, … and we want to replace dash. … We need to embed that within double quotes, … comma, … let's replace that with nothing. …