Capitalizing

[Guest]

How do I capitalize the first letter of every word in an existing column or
row which is very very long? Is there a way to do this without using the
PROPER function?

 

[Bob Phillips]

Why would you want to?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Guest]

The excell sheet is generated automatically form web registrations and
sometimes people do not capitalize their own first and last names. Do you
know how i could do this? Thank you

 

[Bob Phillips]

No, I mean why would you not use PROPER. Do you need to do it by macro,
something like

Sub Capitalize()
Dim iLastRow As Long
Dim i As Long

iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = iLastRow To 1 Step -1
Cells(i, "A").Value = Application.Proper(Cells(i, "A").Value)
Next i
End Sub


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)