Answer the following questions about the formula below:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(AU2,"<competitor1>",$C2),"<competitor2>",$D2),"<usecase1>",$I2)
Where is the paragraph text where you?re substituting the variables?
Which cell can you find <competitor1>?
Which cell can you find <competitor2>?
Which cell can you find <usecase1>?
****
And why is there three "substitute" in this formula?
Thanks
Bookmarks