As you can see, though, these examples can perform some very useful text manipulations.
The examples in this section appear more complex than the examples in the preceding section. =SUBSTITUTE(A1,”Profit”,”Loss”) Advanced Text Formulas This next formula uses the SUBSTITUTE function to accomplish the same effect in a more efficient manner: The following formula searches for the six-letter word Profit and replaces it with the word Loss:
