![]() |
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, |
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, |
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