Learn step by step how to use SUBSTITUTE Function. SUBSTITUTE Function is used when you want to replace text based on its content but not the position.