G Guest Jul 15, 2005 #3 have a look at the caseconvert add-in available from http://www.cpearson.com/excel/download.htm