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
Police Christmas party fund raising scheme
Friday, December 01, 2006 10:29:11 AM (GMT Standard Time, UTC+00:00)
I know it's an oldie but it still makes me smile and I haven't seen it for a while (all the more suitable now I drive a car that can go faster than the speed limit)...
Discount codes galore!
Wednesday, November 29, 2006 4:27:10 PM (GMT Standard Time, UTC+00:00)
Ok seeing as I didn’t get my arse in gear with the 40% discount voucher for the Threshers Group and just about everyone had already seen it, I thought I should post these quickly –hope they’re of use for someone:
And don’t forget to get your naughty adult/sex toys from Miss Mays, I’m still waiting for them to get a code over to me but I’ll update you when I’ve got one…
Update: It's finally here, check out Miss Mays Adult Store finally releases discount voucher
A song about Lovely Birmingham
Wednesday, November 29, 2006 12:18:43 PM (GMT Standard Time, UTC+00:00)
I'm not a fan of YouTube but I was sent this video this morning and it made me smile, I must find out when the choir's next in town...
Father Christmas of the future?
Wednesday, November 29, 2006 10:45:37 AM (GMT Standard Time, UTC+00:00)
I saw the new Debenhams Christmas advert this morning which
featured a young father Christmas dancing around what I can only assume was a
modern Santa’s grotto and I couldn’t help wondering whether this will be the
way forward for Santa in the future –no more fat old bearded man…
I hope not anyhow, why should he have to go on a diet and
trim his beard neatly!
40% discount voucher for the Threshers Group
Tuesday, November 28, 2006 10:40:21 AM (GMT Standard Time, UTC+00:00)
For those of you who like to dabble in a little festive cheer, I thought I’d share this 40% discount voucher for the Threshers Group. The main catch is you’re only allowed to spend £500 at a time –best get that printer started…
Download the 40% discount voucher for the Threshers Group.
The voucher is valid until 10th December 2006
Update: If you're looking for some naughty fun this Christmas, check out the Miss Mays Adult Store discount voucher
Deleting "Ghost" extensions from FireFox
Friday, November 24, 2006 4:18:23 PM (GMT Standard Time, UTC+00:00)
Since updating Firefox to v1.5 I had a number of extensions that I couldn’t remove from the list because they were greyed out, this was somewhat irritating as I had the later versions installed too and so I was getting duplicates (see below)
Today I decided to see if I could resolve this, it turns out removing these ghost/incompatible extensions is fairly simple:
- Close any instances of Firefox you have open
- Navigate to %Documents and Settings%\Username\Application Data\Mozilla\Firefox\Profiles\*.default\
- Backup the file: “extensions.rdf”
- Open “extensions.rdf” in a text editor i.e. Notepad or TextPad
- Find the line that starts with: <RDF:Seq RDF:about="urn:mozilla:item:root">
Below is a list of the extensions you have installed, I can only talk about my case but the ones that were greyed out extensions in Firefox were the ones that had a resource value of a URL rather than “urn:mozilla:item:{Guid}”. My file looked like this:
Simply delete these lines from the file, save it and restart Firefox. All should be back as it should be now…
A simple tale
Tuesday, November 21, 2006 9:29:34 PM (GMT Standard Time, UTC+00:00)
A man was crossing a road one day when a frog called out to him and said, "If you kiss me, I'll turn into a beautiful princess." He bent over, picked up the frog, and put it in his pocket.
The frog spoke up again and said, "If you kiss me and turn me back into a beautiful princess, I will tell everyone how smart and brave you are and how you are my hero" The man took the frog out of his pocket, smiled at it, and returned it to his pocket.
The frog spoke up again and said, "If you kiss me and turn me back into a beautiful princess, I will be your loving companion for an entire week." The man took the frog out of his pocket, smiled at it, and returned it to his pocket.
The frog then cried out, "If you kiss me and turn me back into a princess, I'll stay with you for a year and do ANYTHING you want." Again the man took the frog out, smiled at it, and put it back into his pocket.
Finally, the frog asked, "What is the matter? I've told you I'm a beautiful princess, that I'll stay with you for a year and do anything you want. Why won't you kiss me?"
The man said, "Look, I'm a computer programmer. I don't have time for a girlfriend, but a talking frog is cool."
Prank Caller
Monday, November 20, 2006 2:08:05 PM (GMT Standard Time, UTC+00:00)
I was sent this comedy prank call this morning so thought I'd share it...
Demolition Girl prank caller (DemolitionGirl.mp3)
Vista headaches already –and it’s not even released yet!
Monday, November 20, 2006 10:10:17 AM (GMT Standard Time, UTC+00:00)
I installed a copy of Vista onto a Virtual PC for testing purposes and due to the way this PC is configured Virtual PC always catches me out and sets the default network adaptor as my VPN which means I can’t get any internet connectivity on the Virtual PC, once switched over I also need to change the DNS settings of the PC to work with our router.
The issue I came across this morning though was Microsoft Vista’s activation grace period had expired and there was no way to update the DNS settings to allow the Virtual PC access to the internet to activate my copy which meant I was locked out with no way of updating the network settings to allow validation!
Note: this is just an evaluation copy that you can download from Microsoft so the key won't validate on the release version!
Calling the helpline sorts the issue but it was a 20minute phone call of entering in digits I could have done without!