15 Dec 2007 at 11:36 #1 jamoor jamoor Soldato Joined 22 Jun 2005 Posts 9,068 Location Nottinghamshire I have an excel spreadsheet with 10,000 cells, all the words are in CAPITALS Any way to remove the capitals, or better yet capitalise the first letter of each word?
I have an excel spreadsheet with 10,000 cells, all the words are in CAPITALS Any way to remove the capitals, or better yet capitalise the first letter of each word?
15 Dec 2007 at 12:48 #2 Si MPS Si MPS Associate Joined 20 Jun 2004 Posts 984 Location Manchester Find a few spare columns Use the following formula =PROPER(CELL) This will convert the contents of that cell to Capitalised then lower case. Copy this and paste the values overwriting the capitals.
Find a few spare columns Use the following formula =PROPER(CELL) This will convert the contents of that cell to Capitalised then lower case. Copy this and paste the values overwriting the capitals.
15 Dec 2007 at 17:58 #3 Bomag Bomag Associate Joined 5 Nov 2003 Posts 1,035 Location Leeds Highlight then shift F3 to cycle through upper case>lower case>leading capitals. It doesn't work in all versions. Last edited: 15 Dec 2007
Highlight then shift F3 to cycle through upper case>lower case>leading capitals. It doesn't work in all versions.
15 Dec 2007 at 19:36 #4 bledd bledd Don Joined 21 Oct 2002 Posts 46,825 Location Parts Unknown =PROPER(A1) if A1 contained.. "THIS IS a test" that would output as "This Is A Test" could replace PROPER with UPPER or LOWER
=PROPER(A1) if A1 contained.. "THIS IS a test" that would output as "This Is A Test" could replace PROPER with UPPER or LOWER
15 Dec 2007 at 23:43 #5 jamoor jamoor Soldato OP Joined 22 Jun 2005 Posts 9,068 Location Nottinghamshire brillant, worked a treat thanks very much!
