Hi all, Does anyone know a simple way to change the case of text in an excel spreadsheet by column? Someone told me there is a formula for this but I cannot find it anywhere :-) Much appreciated. Rebecca Caldwell IDC Technologies Technology Training That Works