| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
uppercase to lowercase
I have mixed case text in cells that I would like to have all in lowercase.
What can I use to make this happen? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
uppercase to lowercase
wagz,
With formulas, you can use the LOWER() function. With VBA, you can use the LCase() function -- Hope that helps. Vergel Adriano "wagz" wrote: I have mixed case text in cells that I would like to have all in lowercase. What can I use to make this happen? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
uppercase to lowercase
Great! Works perfect. Thanks!
"Vergel Adriano" wrote: wagz, With formulas, you can use the LOWER() function. With VBA, you can use the LCase() function -- Hope that helps. Vergel Adriano "wagz" wrote: I have mixed case text in cells that I would like to have all in lowercase. What can I use to make this happen? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| uppercase to lowercase | Excel Discussion (Misc queries) | |||
| Lowercase to uppercase | Excel Discussion (Misc queries) | |||
| lowercase to uppercase | Excel Programming | |||
| lowercase to uppercase | Excel Worksheet Functions | |||
| uppercase to lowercase | Excel Discussion (Misc queries) | |||
Hybrid Mode
