Adjusting character content with REPLACE and SUBSTITUTE

- If you need to replace information in Excel,…there is a command called Edit, Replace,…but there also two functions, one called REPLACE…and one called SUBSTITUTE.…One is based on positioning, that's the REPLACE function,…and one is based on content, that's the SUBSTITUTE function.…As we look at the data in cells A2 to A5,…we might want to replace the fifth character…with a certain character.…The heading here says replace the fifth character with an X,…so in cell A2, the fifth character…from the left is the dash.…

We're gonna replace that with an X.…The REPLACE function gives us some options.…First of all, where are we looking?…We're looking in cell A2, that's referred to as old_text.…Comma.…Now, we can replace one or two or three or four characters,…in this case just one, with the starting number…there is five, that's the starting position.…Now, we're trying to get rid of the dash and replace it…with an X, so what we are replacing is a single character,…comma, and replacing it, in this case,…with only one other character.…