I have a text column which is a description, and it's all in upper case. Inside my analyses, only two options are available to convert it. The first option is using a function, but the only string functions available are either UPPER() or LOWER().
The second possible option is the Data Format tab in Column Properties. But this has no instructions and I have no idea how it might help.
Also, there may be some abbreviations that are meant to stay all upper case. If none of this can be done, then I will stop wasting my time on it.
Thanks in advance!