Select the cells you want to change and run this little macro:

Sub properr()
For Each r In Selection
r.Value = Application.WorksheetFunction.Proper(r.Value)
Next
End Sub


--
Gary''s Student - gsnu200836


"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