Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
changing lower case to upper case | Excel Discussion (Misc queries) |