Capitalizing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Why would you want to?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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
 
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)
 
Back
Top