Go Back   Technibble Forums > Technical Discussions > Software Applications

  Technibble Sponsor

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 05-01-2012, 08:07 PM
KompuKare's Avatar
KompuKare KompuKare is online now
 
Join Date: Jan 2010
Location: UK
Posts: 438
KompuKare is on a distinguished road
Send a message via MSN to KompuKare Send a message via Skype™ to KompuKare
Default

Quote:
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 10:02 PM.


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