I would like to use a piece of text entry to create an ID code, I will be using the first three letters of a location entered as text in a calculation.
Is there a way to convert this text to upper case so those three letters are all capital letters?
I would prefer not to go down the route of forcing entry in upper case using regex.