Simple replace function?

[derohanes]

Is there an easy way to replace a portion of a string without using left/mid/right functions? The best way to explain is by example. Lets I have in a cell, "Tuesday is the best day of the week," and I want to input into another cell, "Tuesday is the worst day of the week." Is there a simpler way of substituting "worst" for "best" with out having to find the positions and clipping and re-assembling? Something like find "best", replace with "worst".

 

[Joe4]

There is function for that called SUBSTITUTE. It is pretty straightforward, i.e.

=SUBSTITUTE(A1,"worst","best")