Upper/Lower Case in Excel 1

[LewisReeder]

I currently have a column of names(first and last), some are all caps, some are both caps and lower case, some have a middle initial with a period, and some don't have a middle name at all.

I'd like them all to have the first letter of each name capital and the rest of the name lower case so for example if I have "JOE e. smith" I'd like it to look like "Joe E. Smith".

Any advice would be greatly appreciated.

Thanks!

Lewis

 

[combo]

=> PROPER function.

combo

 

[LewisReeder]

Thanks!