Take a look at David McRitchie's Upper() macro: http://www.mvps.org/dmcritchie/excel/proper.htm#upper Bold: CTRL-b