Use the SUBSTITUTE function to replace text

Use the SUBSTITUTE function to replace text

Syntax: SUBSTITUTE(text, old_text, new_text, [instance_num])

Step 1: Define the text, old_text, new_text, and optionally the instance_num.

Step 2: Enter the formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com