Sorry - how do I do this to an entire column? Rebecca :-) ________________________________ From: austechwriter-bounce@xxxxxxxxxxxxx [mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of David Godley Sent: Tuesday, 7 July 2009 8:16 AM To: austechwriter@xxxxxxxxxxxxx Subject: atw: Re: change case in Excel Upper() Lower() On Tue, Jul 7, 2009 at 9:42 AM, Rebecca Caldwell <rebecca@xxxxxxxxxxxxxx> wrote: 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 :-)