Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help correcting capitilization in worksheet that is entirely caps!
Someone please help! I am not a very good excel user by far and I have been
trying all day to fix a worksheet that has over 3000 lines. The text cells are all written in caps, I need to fix it to where they are properly capitilized. I would even rather them be all lower case than upper. I don't know how to change it, I tried the formula in help but I cant figure it out. Please help if you know how to change it, I don't want to have to retype the entire sheet. I did find a thread on macros, but have no idea how to do that either. So here I am the dummy. Can anyone help? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help correcting capitilization in worksheet that is entirely caps!
If your input is in column A, say A1:A3000, then in cell b1 enter the formula
=proper(A1). Autofill that formula through the entire column. If that looks okay, you can than select column B, Edit Copy, select column A and Edit Paste Special, select Values and click OK. Then clear column B. (To paraphrase another frequent poster, please backup your file before making significant changes!). --Bruce "wranglerred" wrote: Someone please help! I am not a very good excel user by far and I have been trying all day to fix a worksheet that has over 3000 lines. The text cells are all written in caps, I need to fix it to where they are properly capitilized. I would even rather them be all lower case than upper. I don't know how to change it, I tried the formula in help but I cant figure it out. Please help if you know how to change it, I don't want to have to retype the entire sheet. I did find a thread on macros, but have no idea how to do that either. So here I am the dummy. Can anyone help? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help correcting capitilization in worksheet that is entirely caps!
See
http://www.mvps.org/dmcritchie/excel/proper.htm In article <5a59558874473@uwe, "wranglerred" <u17646@uwe wrote: Someone please help! I am not a very good excel user by far and I have been trying all day to fix a worksheet that has over 3000 lines. The text cells are all written in caps, I need to fix it to where they are properly capitilized. I would even rather them be all lower case than upper. I don't know how to change it, I tried the formula in help but I cant figure it out. Please help if you know how to change it, I don't want to have to retype the entire sheet. I did find a thread on macros, but have no idea how to do that either. So here I am the dummy. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) |