Hi, I am wondering how I can get excel to automatically capitalize words in a cell that I input. I would like to enter the title of DVD/Blu-rays that I have and get it to be proper after I go to the next cell. For instance I would like to enter: it's a wonderful life and get It's a Wonderful Life. The way I have it now it will go "It'S A Wonderful Life". Also I would another colum of cells to also auto capitalize words I type in like: "sci-fi to Sci-Fi, comedy to Comedy etc". Any help would be greatly appreciated. Thanks in advance.
Dave
Dave