Capitalizing

[Olga_Kosh]

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)

"Olga_Kosh" <Olga_Kosh@discussions.microsoft.com> wrote in message
news:31ABF1EC-5C5F-47C5-A59F-0337513356D5@microsoft.com...
> 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?

[Olga_Kosh]

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" <Olga_Kosh@discussions.microsoft.com> wrote in message
> news:31ABF1EC-5C5F-47C5-A59F-0337513356D5@microsoft.com...
> > 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]

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" <OlgaKosh@discussions.microsoft.com> wrote in message
news:02953B1B-DDBB-4B2E-A589-660864BCFF08@microsoft.com...
> 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" <Olga_Kosh@discussions.microsoft.com> wrote in message
> > news:31ABF1EC-5C5F-47C5-A59F-0337513356D5@microsoft.com...
> > > 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?
> >
> >
> >