View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default 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,