Thanks for your help, does this mean i need to copy each column (eg A, B, C,
D) individually into the new spreadshee. Its a huge database wit about 2,000
names and address and for mail merging purposes i require it in proper case.

"carlo" wrote:

Hi Amanda

do you need to do it once, or lots of time?

If you need to do it once, make a new sheet, enter this formula to A1:
=proper(sheet1!A1)
you need to change sheet1 to whatever your sheetname is.
then, take the cell handler, and drag it down (may take a while)
After that with the whole column A selected, take the handler again
and drag it to the right to column IV.
Then press Ctrl+C, then right-click, paste special..., choose "values"

if you need to do it often, a sub might come in handy.
Something like:

Sub AllToProper()

For Each cell_ In ActiveSheet.UsedRange
If cell_.Value < "" Then
cell_.Value =
Application.WorksheetFunction.Proper(cell_.Value)
End If

Next cell_

End Sub

hth

Carlo

On Jan 9, 9:36 am, Amanda17
wrote:
How can i change a whole database of capitals to proper case, i know the
=PROPER formula but i cant figure out how to work it for the whole
spreadsheet. Can someone PLEASE help me I really need this for work.