Originally Posted by techyguy717
Thank you, altrenda and everyone else. This saved a lot of time.
I was copying the formula, but was not pasting the formula correctly.
I merely pasted.
After copying the formula I need to:
- Paste Special
- Paste as Formula
No you don't: you fill down CRTL-D (or right, CTRL-R). Alternatively you could copy everything to clipboard, paste into Word, get it to toggle case (Word calls it TitleCase) and paste special the values back in. You'd lose any formulas though. If all the offending UPPERCASE stuff is confined to whole rows or columns you can just copy those though.
If doing this a lot, VBA is the way to go though.