Hi,

I'm not entirely certain how you enter code in Excel 2007 but try this
anyway. Right click your sheet tab and click 'View Code' and paste the code
below in on the right hand side. Select the column of text and run the code

Sub Marine()
For Each c In Selection
c.Formula = WorksheetFunction.Proper(c.Formula)
Next
End Sub

Mike

"Jbm" wrote:

Forgot to say what version I'm running: Excel 2007.