Text Transforming? Could really use a minute of help...

I have an un-organized mess of data that I need to format to fit a certain style in order to be consistant with the database it will be added to here at work. Basically, I got this job by being not-so-honest about my excel skills and now I'm sweating it.

I have hundreds of rows all caps names that I need to convert to first letter capital and the rest lowercase.

Is there a way excel can make this easier for me?

Ok, I can get that to work one at a time. but not all at once.

For example,

One of the columns that I need converted is column D - starting at D2. So I inserted a new column between D and E - this is my new E column. In column E at row 2. I wrote

=PROPER(D2)

This does the transform, but I can't seem to drag it to do the same function for all the boxes in column E i.e. E3 should equal =PROPER(D3), E4 should equal =PROPER(D4).
When I try it simply turns my orignal =PROPER(D2) into #VALUE!

What do I do?

How do I create a module? I realize this is a dumb question but...that's where I am at...

There are no dumb questions

From excel press Alt+F11 to bring up the visual basic editor, go to the insert menu and choose module

Let me know if you have any problems!

Fantastic. Worked like a charm. I feel like I am not even scrathcing the surface of what this program has to offer.

For example, I need to split names into a First Name column and a Last Name column. But the raw data has both names in a single column - I don't suppose there is a way to get excel to split the names at the space between them into different columns? Probably not, but worth a shot...