| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
In anotehr column apply the below formula and copy down as reuauired. Once
done copyPasteSpecialValues to convert formulas to values... =LOWER(A1) -- Jacob "MAXXMAS" wrote: I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT HAVING TO TYPE IT OVER AGAIN. TKS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
Use the formula LOWER(A1) in an empty column and copy down.
Then copy and paste special as values over your original data. You can then delete the formulas. -- If this helps, please remember to click yes. "MAXXMAS" wrote: I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT HAVING TO TYPE IT OVER AGAIN. TKS |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING
MAXXMAS wrote:
I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT HAVING TO TYPE IT OVER AGAIN. TKS and in the future, toggle your caps lock key off... Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto change all caps to upper and lower case | Excel Discussion (Misc queries) | |||
| Auto change all caps to upper and lower case | Excel Discussion (Misc queries) | |||
| Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
| Caps to lower case | Excel Discussion (Misc queries) | |||
| Change source text in Excel from all caps to upper and lower case. | Excel Discussion (Misc queries) | |||
Linear Mode
