I am trying to make everything in multiple columns and hundreds of rows into proper case. They are in all caps and need them to be proper. I tried the PROPER function but it does not work. Can this function work with numbers and letters in the cell? if so, can someone right me the formula?

It's really very simple. Here's how the formula should look: =PROPER("jane doe") Cell will show: Jane Doe Soylent Green is PEOPLE!!!

The freebie ASAP Utilites has the feature. Look at the screenshots under "Text". It has several options: Convert to Uppercase Convert to lowercase Start first word with uppercase Start each word with uppercase It can do the entire sheet at once. Since it uses macros the changes can not be undone so use Save As to another sheet before trying things with it to preserve the original sheet's data. You install it as an Add-in so it will start each time you open Excel but I find it to be worth it. It slows the opening of Excel by an exceptable amount. I don't use it's features too often but when I need one of it's ~300 functions it sure comes in pretty handy. Do look at it's installation options to set it to your needs and desires. You can always uninstall it later. HTH Bryan

I downloaded, and installed it, but how do I change all the cells that I already done at once. There is some 8000 rows and about 20 columns. Need to make them all proper case.

Open the visual basic editor, copy and paste the code below into the sheet. Then run the macro, it will convert everything to uppercase. Sub uppercase() For Each cel In ActiveSheet.UsedRange cel.Value = UCase(cel.Value) Next End Sub

I already have everything uppercase, that is the problem. I need everything proper.

Select/highlight the data and then click on the function of choice. Bryan