View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deepak Deepak is offline
external usenet poster
 
Posts: 47
Default Format Case for only

Hi,
I have names in one column, I need formula to convert the names in to proper
case. but if there is any 3 character word it should be in Upper case.
Plz Help...

eg.
AAA SYSTEM change into AAA system
DELL COMPUTERS change into DELL Computers
MOBILE BPL change into Mobile BPL
SIMMONS LAD change into Simmons LAD
A V SYS MEDIA PVT LTD change into A V SYS Media PVT LTD

It should change the case to upper for 3 letter words and rest to Proper case