Take a look he

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

In article ,
AllenH wrote:

I want ot change a Excel speadsheet from a combination of upper and lower
case to all uppercase ie all 'Capitols'.