If this is a duplicate question, I apologize. Not sure my first made it.

Some simple text functions work in some of my worksheets but not in others.
Could I have reset some crucial option/property?