After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat:
Accept ranges in the SUBSTITUTE function. WHY NOT allow ranges for the "old_text" and "new_text" so that we can swap many old_texts for new_texts without nesting many Substitute functions?
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!