Excel: Auto Capitalization of movie names.

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

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of January 16, 2014.

For more resources for Microsoft Excel