In that case, try:
Code:
Sub Reformat()
Dim i As Long, StrTmp As String
With Selection
For i = 1 To .Words.Count
If .Words(i) = LCase(.Words(i)) Then
StrTmp = StrTmp & .Words(i)
Else
StrTmp = StrTmp & UCase(Left(.Words(i), 1)) & LCase(Mid(.Words(i), 2, Len(.Words(i)) - 1))
End If
Next
.Text = StrTmp
End With
End Sub