Go Back   Technibble Forums > Technical Discussions > Software Applications

  Technibble Sponsor

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 05-01-2012, 09:07 PM
KompuKare's Avatar
KompuKare KompuKare is offline
Join Date: Jan 2010
Location: UK
Posts: 466
KompuKare is on a distinguished road

Originally Posted by techyguy717 View Post
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.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 12:06 PM.

Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Technibble.com is based out of MELBOURNE, AUSTRALIA.