| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAPITALIZED ALL WORDS FROM WROKSHEET
dear sir,
i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CAPITALIZED ALL WORDS FROM WROKSHEET
Although all caps isn't recommended for reading and screen size, you can use
the "upper" command. I usually have to do the opposite, with the "Lower", or sometimes the "proper" that capitalizes the first leter only. to convert text in a1, in a blank cell type "=upper(a1)" you can then drag the formula down or across. when you are finished, copy and paste values over the original. "convert all capital letter from excel" wrote: dear sir, i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CAPITALIZED ALL WORDS FROM WROKSHEET
The free Excel add-in "Excel Extras" will do that and more.
Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "convert all capital letter from excel" wrote in message dear sir, i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel underline misspelled words like Word? | Excel Discussion (Misc queries) | |||
| In Excel, How do i add Words together. | Excel Worksheet Functions | |||
| triadic combinations of words | Excel Worksheet Functions | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel | |||
Linear Mode
