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?