Hi,

Suppose the cells are A1:A10

In B1 enter the formula

=PROPER(A1)

Copy it down. Convert the column B formulas to values and replace the
original data.

There are free add-ins on the internet to do this to a selection via a
macro. Take a look at this site

http://www.cpearson.com/excel/ChangingCase.aspx

Or very simple version:

Sub ChangeCase()
Dim cell As Range
For Each cell In Selection
cell.Value = WorksheetFunction.Proper(cell)
Next cell
End Sub


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jo4321" wrote:

I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is
in all capital letters. I'd like to change it so that it is not all caps. I
found the auto correct function for use while typing, however, I haven't
found a way to correct after-the-fact.

Jo