Excel change case -sentance, proper, lower and upper
Tuesday, December 05, 2006 2:38:04 PM (GMT Standard Time, UTC+00:00)
Have you ever been sorting through a client’s product data and needed to change the case of the text? This is a great little add-in for Excel that can help.
Download the zip file and run the xla file, you’ll then have a new option “Convert Text” under your “Tools” menu:
To use it, select the text you want to change and then choose “Convert Text”, you can then choose from:
- lower case
- UPPER CASE
- Proper Case
- Sentence case
It also has a number of other useful options like removing white space, adding characters etc.
Download the Excel Change Case Add-in here
Free copies of the released versions of Windows Vista and Microsoft Office 2007
Saturday, November 04, 2006 10:58:14 PM (GMT Standard Time, UTC+00:00)
This is still unconfirmed and somewhat word-of-mouth etc atm but if you check out Ian Moulster's blog you'll see his post about Microsoft giving away free copies of the release version of Vista and Office 2007 check out his blog post to find out more.
Hopefully we'll hear more before DDD Day
Stopping Outlook Blocking Attachments
Tuesday, July 04, 2006 10:46:14 AM (GMT Standard Time, UTC+00:00)
I know this is covered all over the web but I'm forever forgetting it so if Outlook has started blocking email attachments i.e. ASP files you can easily adjust this by adding a String Key called "Level1Remove" to the registry, navigate to: Current User --> Software --> Microsoft --> Office (x) --> Outlook --> Security (where (x) is the version of office you are running: 9 = Outlook 2000, 10 = Outlook 2002 11 = Outlook 2003
Then right click and choose "New" and "String Key", then add in a list of the attachments you would like to allow seperated by semi-colons i.e.:
.exe;.mdb;.url;.asp;.aspx;.zip