Capital

I would like that the 1st letter of each word should be capitalized, how am I
setting it up?

Use the PROPER function.


=PROPER(A1) where a1 is your text.

HTH

Steve

One way would be to use that standard feature in the ASAP Utilities Add-in,
which is available free at www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Roger" wrote:

> I would like that the 1st letter of each word should be capitalized, how am I
> setting it up?

I downloaded it, what is next step?

"CLR" wrote:

> One way would be to use that standard feature in the ASAP Utilities Add-in,
> which is available free at www.asap-utilities.com
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Roger" wrote:
>
> > I would like that the 1st letter of each word should be capitalized, how am I
> > setting it up?

Install it and then explore its functionality.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Roger" <[email protected]> wrote in message
news:[email protected]...
> I downloaded it, what is next step?
>
> "CLR" wrote:
>
> > One way would be to use that standard feature in the ASAP Utilities
Add-in,
> > which is available free at www.asap-utilities.com
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Roger" wrote:
> >
> > > I would like that the 1st letter of each word should be capitalized,
how am I
> > > setting it up?

If you have it installed, with the "ASAP Utilities" label in the upper
toolbar, then highlight the cells you wish changed and then click on the
"ASAP Utilities" label, then choose "TEXT" and then "Start first word with
uppercase" and then follow the menus.

Vaya con Dios,
Chuck, CABGx3


"Roger" wrote:

> I downloaded it, what is next step?
>
> "CLR" wrote:
>
> > One way would be to use that standard feature in the ASAP Utilities Add-in,
> > which is available free at www.asap-utilities.com
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> > "Roger" wrote:
> >
> > > I would like that the 1st letter of each word should be capitalized, how am I
> > > setting it up?