| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Upper Case Formula for Multiple Cells
Your original data entry will be in whatever case it is entererd in. In an
adjacent cell just add the formula =Upper(??) to reformat the data entry top upper case. I have seen macros and validation routines to force upper case but I kinda like the simple formula method described above... -- HTH... Jim Thomlinson "Elle" wrote: I want a range of cells to atomatically be in upper case with out having to change the case on my keyboard. Can I apply the Upper= formula to a column of cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
| Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
| How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
| Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
Linear Mode
