Changing formula to Upper case

[Abdul]

Hello,

If we type a built in formula it automatically changes to upper case.
How we can make a custom function to automatically change to upper
case?

Thanks,

 

[John Bundy]

All depends on where and how you are using it, but take the inputted text,
UCase(text) and put it back out. Ucase changes what is in the () to uppercase.

 

[JE McGimpsey]

There's no way, AFAIK, to automatically force the conversion.