G
Guest
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
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