| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Capital
I would like that the 1st letter of each word should be capitalized, how am I
setting it up? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing capital letters | Excel Discussion (Misc queries) | |||
| Sorting a Worksheet using Capital letters | Excel Worksheet Functions | |||
| capital letters to lowercase | Excel Discussion (Misc queries) | |||
| Sentence with first letter in Capital, rest all in small. | Excel Discussion (Misc queries) | |||
| Template for IRS form capital gains/losses | Excel Discussion (Misc queries) | |||
Linear Mode
