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)

"Olga_Kosh" wrote in message
...
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?

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" wrote:

Why would you want to?

--

HTH

Bob Phillips

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

"Olga_Kosh" wrote in message
...
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?

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)

"Olga_Kosh" wrote in message
...
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" wrote:

Why would you want to?

--

HTH

Bob Phillips

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

"Olga_Kosh" wrote in message
...
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?