Using the Replace and Find Functions in Excel to Modify Strings

This video demonstrates how to use the REPLACE and FIND functions in Excel to modify strings. The REPLACE function is useful when text with a known location in a string needs to be replaced by a new string. The FIND function can be combined with the REPLACE function when the location is not known.