ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing formula to Upper case (https://www.excelbanter.com/excel-programming/402511-changing-formula-upper-case.html)

Abdul[_2_]

Changing formula to Upper case
 
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

Changing formula to Upper case
 
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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Abdul" wrote:

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,



JE McGimpsey

Changing formula to Upper case
 
There's no way, AFAIK, to automatically force the conversion.
In article
,
Abdul wrote:

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,



All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com