Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
how can I convert all normal text to all CAP text?
thks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
=UPPER(A1)
"Christine" wrote: how can I convert all normal text to all CAP text? thks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
Hi,
=UPPER(A1) works on a cell by cell basis, if you want to do a large range there are a number of utilities to do this in Excel. There is free code at this site: http://www.ozgrid.com/VBA/change-case-text.htm or a free download here http://www.freesharewarecenter.com/E...e,_-70937.html and many others, don't pay for code to do this! -- Thanks, Shane Devenshire "Christine" wrote: how can I convert all normal text to all CAP text? thks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
Press Alt+F11 to go to the VBA editor, click Insert/Module from its menu bar
and then copy/paste this macro into the code window that appeared... Sub UpperCaseText() With ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants) .Formula = UCase(.Formula) End With End Sub Now, go to the worksheet you want to capitalize the text on, press Alt+F8 to bring up the macro dialog box, select UpperCaseText from the list and then click the Run button. If there are other worksheets you want to do this on, activate the worksheet and then repeat the instructions from previous sentence. -- Rick (MVP - Excel) "Christine" wrote in message ... how can I convert all normal text to all CAP text? thks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
hi, Christine !
how can I convert all normal text to all CAP text? you might want to give a try to the following: if available, try to change the font for your range/worksheet/workbook/style/... (no other tricks/code/stuff/... needed) no matter if user types in lower/upper case... this fonts shows text un uppercase: - Castellar - Engravers MT - Felix Titling - Stencil - Technic (*versalles* type) this font shows text in lowercase: - Freshbot - Poornut - Pussycat hth, hector. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
Hi,
If your normal text is in A1, try using =UPPER(A1) Or consider using Data Validation, Custom to force entry in Uppercase only. =EXACT(A1,UPPER(A1)) Dave url:http://www.ureader.com/msg/104241298.aspx |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to convert all words to CAPS
Hi Hector
this is great! no formula or other stuff... cheers "Héctor Miguel" wrote: hi, Christine ! how can I convert all normal text to all CAP text? you might want to give a try to the following: if available, try to change the font for your range/worksheet/workbook/style/... (no other tricks/code/stuff/... needed) no matter if user types in lower/upper case... this fonts shows text un uppercase: - Castellar - Engravers MT - Felix Titling - Stencil - Technic (*versalles* type) this font shows text in lowercase: - Freshbot - Poornut - Pussycat hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
Convert to Caps | New Users to Excel | |||
How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
Is there a way to have a function auto correct words in ALL CAPS . | Excel Worksheet Functions |