| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing "case" of letters
I have a huge database in excel.
Unfortunately, some of the entries are in ALL CAPS (E. MAIN ST or JOHN SMITH) It is unfortunate as they need to be E. Main St or John Smith. Is there any way to fix this without retyping every entry? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lower case letter "i" always converts to upper case | Excel Discussion (Misc queries) | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| how do I count only lower case "x" and exclude upper case "X" | Excel Worksheet Functions | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
![sos-DC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
