From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Adjusting character content with the REPLACE and SUBSTITUTE functions

Adjusting character content with the REPLACE and SUBSTITUTE functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Adjusting character content with the REPLACE and SUBSTITUTE functions

“

- Excel has two similar functions, one called Replace, one called Substitute. Both of them allow us to replace characters within text strings. They're very similar, and there's also a command on the Home tab far-right button, Find and Select called Replace. Now unfortunately, adding to a bit of confusion here, this Replace command which we'll look at in a bit is very similar to the Substitute function, not the Replace function. Let's first look at the two functions. The Replace function allows us to replace information based on a position. We need to replace the fifth character in these codes with the letter X. Let me zoom in, holding down Control using the mouse wheel. The Replace funcion. Old text refers to this location right here, looking in cell A3 comma, and starting in the fifth position comma, we want to replace one character, one with another character or characters possibly, in this case just one character. If it's a text entry, it must be within double quotes, "X". We have…

Contents