Replace

Overview

REPLACE will remove a subsring of a string to be replaced with another substring. Input 1 is the full string, input 2 is the substring to be replaced and input 3 is the substring that will be replacing substring of input 2 in input 1.