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".