10 Mar 2006 at 10:38 #1 CLAWS CLAWS Associate Joined 13 Jun 2005 Posts 1,416 Location West Midlands Very quick question. I have a column in Excel containing 400 cells of text in upper case. Is there a way to change all the text from upper case to lower case instead of retyping all 400 cells of text? TIA
Very quick question. I have a column in Excel containing 400 cells of text in upper case. Is there a way to change all the text from upper case to lower case instead of retyping all 400 cells of text? TIA
10 Mar 2006 at 10:43 #2 Borris Borris Caporegime Joined 25 Oct 2002 Posts 30,409 CLAWS said: ... Click to expand... Code: =UPPER(A1) F1 is your friend. Still. The Office help function, as I said last time, is very good for this sort of thing.
CLAWS said: ... Click to expand... Code: =UPPER(A1) F1 is your friend. Still. The Office help function, as I said last time, is very good for this sort of thing.
10 Mar 2006 at 10:50 #3 CLAWS CLAWS Associate OP Joined 13 Jun 2005 Posts 1,416 Location West Midlands Sorted!!! Cheers Borris!
