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 23:43 #5 jamoor jamoor Soldato OP Joined 22 Jun 2005 Posts 9,068 Location Nottinghamshire brillant, worked a treat thanks very much!
