Capital
 

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

Capital
 

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?

Capital
 

Use the PROPER function.


=PROPER(A1) where a1 is your text.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=541642

Capital
 

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?

Capital
 

Install it and then explore its functionality.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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

Capital
 

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?