Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Odds and Sods     Software     Acrobat     Equipment     Hardware     Browsers     News     Education         Utilities     Bits and Bobs     Plausible Lies     Flatpress     Overcoming Disabilities     Word     Family     PHP     Tutorials     Bookmarks     VBA     Excel     Windows     Reviews  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

Want one!

Permalink: http://paul.us2uk.eu/?x=entry:entry161229-004337

A South Korean company has unveiled a prototype for the world’s first manned, two-legged robot. It’s 4m High!

When it came up with “Potential uses” on the video I thought the first one should be to fight other 4m high robots!

I wonder when we’ll ever see the first manned walking robot on the moon?

http://www.bbc.com/news/technology-38442672

image

Excel Functions - Version Compatibility

Permalink: http://paul.us2uk.eu/?x=entry:entry161117-162809

While working on a spreadsheet today I was using the ISERROR function to test if a VLOOKUP formula returned a value and, if it did, return the value otherwise display nothing - instead of the usual #N/A error notification.

The usual syntax for this formula begins “=IF(ISERROR(VLOOKUP(…”.

I happened to notice that Excel 2010 (the version I use at work) offered up “IFERROR” as a possible function as soon as I typed the “IF” and, indeed, this allows me to write slightly shorter formula. However this is not backwards compatible with Excel 2003 which I use elsewhere so I avoided using it.

For anyone faced with a situation where they have a spreadsheet containing lots of instances where the a formula contains “IFERROR” then help is at hand at the following link - untested, but I’m sure it’ll work. I’ve bookmarked it here because it looks like quite a useful site.

http://www.professionalexcel.com/2011/06/replace-iferror-with-ifiserror/

There are obviously a few more functions which were added in later versions of Excel which you should avoid using if you don’t want your spreadsheet to fail when someone opens it in Excel 2003 (which I much prefer!). The other one I avoid for this reason is “SUMIFS” (I use “SUMPRODUCT” instead) but here’s a useful list of all Excel functions showing which versions they are compatible with - plus a useful description of each..

https://docs.google.com/spreadsheets/d/1ztUAhgAghKn2wNih7-QgMbSAKfux4w_qkAcJdD82bLU/edit

Here’s the same thing downloaded for posterity as an XLSX file

Windows 10 Update Freezing Computer

Permalink: http://paul.us2uk.eu/?x=entry:entry161107-001648

Windows 10 Logo When a monster update came through and installed itself on our Windows 10 laptop,  aside from suddenly getting annoyed to death by “Cortana” (some stupid Microsoft “help thing”, I think - not asked for nor desired, anyway) the laptop - a Dell - just started freezing up after a few minutes of use.

If this happens to you (and you could care less about ditching Cortana) then try this first before tearing your hair out. [Read More…]

Fix for Windows 10 Can’t Connect To This Network

Permalink: http://paul.us2uk.eu/?x=entry:entry161025-233719

The solution to this extremely annoying recurring problem which worked for me was this:

[Read More…]

Merging cells in Excel can lead to formula errors

Permalink: http://paul.us2uk.eu/?x=entry:entry160930-180600

As I’ve just discovered after so many years of using Excel if you merge a group of cells and then use a lookup (I only ever use VLOOKUP but it will probably apply to HLOOKUP too) to return the value from that merged group of cells, then you run the risk of getting the wrong result.

Here’s why, and why you should NEVER use merged cells in part of your spreadsheet which you might (one day) want to look up date from via a formula…. [Read More…]

What’s the crake?

Permalink: http://paul.us2uk.eu/?x=entry:entry160901-190400

I feel somewhat vindicated in my stance that the correct term for “good banter” in Ireland and Britain is “crack”, not “craik”, and not “craic”.

http://www.scotland.com/forums/language/15676-craik-crack.html

It seems that the correct spelling was and will always be “crack”.

The so-called Gaelic spelling (craic) is a fairly recent introduction and is not a Gaelic word at all, it is purely an attempt to make a Gaelic-sounding word out of the original - perhaps because of the narcotic connotation of the correct spelling or maybe just because too many people from the old country want to sound like they’ve just stepped off the steamer from Queenstown.

I’m sure it will continue to be used in all of the thousands of “Irish Bars” which are dotted around the world and will, eventually, be pronounced “crake”.

So there you have it.

Fix for no audio/sound via HDMI

Permalink: http://paul.us2uk.eu/?x=entry:entry160829-132605

I have a recurring problem with my media PC dropping the HDMI audio output to my big Sony TV - and I keep forgetting how to fix it (because it’s quite a simple fix but it’s not that obvious how to do it).

Why this happens is anyone’s guess but, for some reason, the TV gets disconnected or disabled somehow - AND THEN HIDDEN in the choice of speakers when you click in the speaker icon in the system tray (where the clock is).

Here’s where I refreshed my memory but, although this says it is for Windows 10 it does also work just the same in Windows 7, which is what I have installed. You may find some additional solutions there, if this doesn’t work for you:

https://www.drivereasy.com/knowledge/fix-hdmi-monitor-has-no-sound-after-windows-10-upgrade/

I knew I had to right-click somewhere and get the Plackback Devices panel to show my TV as an option but I couldn’t remember where. Well, all you need to do is RIGHT click on a BLANK AREA of the panel (right-click on the speaker icon then choose “Playback devices” to show the panel, then see the picture below) and then make sure that both “Show Disabled Devices” and “Show Disconnected Devices” are checked.

This continues to solve the problem for me. I hope this has helped you too!

image

Find and Replace Line Breaks in Excel

Permalink: http://paul.us2uk.eu/?x=entry:entry160812-105344

One of the most frequent things I forget how to do is the replacement of line breaks in Excel cells. You can put a line break in an Excel cell simply by pressing Alt+Enter while you are typing in your data, but sometimes you want to replace some of the text PLUS the line break.

To do this is equally simple (once you know how) just by entering Ctrl+J so say you have a cell with the following data with a line break in it:

ABC
XYZ

and you want to either replace or even remove the top or bottom line you would go to your Find & Replace dialogue box (press Ctrl+H) to bring this up and then enter either of the following in the “Find what:” box…

To remove the top line type “ABC” then press Ctrl+J (it will not actually show anything because the Find what box is only one line high, and you might just be able to make out the top of the insertion point I-bar cursor flashing below the A), then type in whatever you want in the “Replace with:” box - or just leave it blank if you want to delete that top line.

To remove the bottom line first press Ctrl+J THEN type “XYZ”. In this case you might not see anything when you type the “XYZ” except (again) the flashing top of the cursor moving along as you type the letters on what a line which is hidden by the restricted height of the “Find what:” box.

Thanks to Debra Dalgleish for this excellent tip ever at her equally excellent Contextures Blog…

http://blog.contextures.com/archives/2013/05/28/find-and-replace-line-breaks-in-excel/

Dad’s Army Story - Victoria Wood

Permalink: http://paul.us2uk.eu/?x=entry:entry160425-005228

Dad’s Army Story

I don’t know Jack

Permalink: http://paul.us2uk.eu/?x=entry:entry160415-143737

David Lynch funded this documentary about the star of possibly the strangest, most intensly photographed film I’ve ever seen.

https://www.youtube.com/watch?v=-cSZvOyZNtU

A documentary about Jack Nance, star of the David Lynch film “Eraserhead”

Add a new FlatPress Blog in Open Live Writer

Permalink: http://paul.us2uk.eu/?x=entry:entry160121-165110

imageOpen Live Writer is the new open source version of Microsoft’s wonderful blogging tool Windows Live Writer, and users of the latter will feel VERY at home with the new open source version (as it’s pretty much the same thing!).

In my previous post I gave you my first impression of it - there was a slight hiccup when I tried to set it up with my first blog account, but here is how to add another blog account once you’re up and running. [Read More…]

Live Writer is now Open Source

Permalink: http://paul.us2uk.eu/?x=entry:entry160120-174435

imageWindows Live Writer is/was a great blogging tool but Microsoft haven’t really supported it for some time now, so thanks to them for allowing it to become open source so it can be developed by the large community of users who love it to bits.

This is my first post using Open Live Writer on FlatPress and it was relatively easy to set up, but not so straightforward as it could have been… so here’s what FlatPress users may* need to know in order to get it working. [Read More…]

How to repair/replace target paths in multiple desktop shortcuts

Permalink: http://paul.us2uk.eu/?x=entry:entry151215-142555

Shortcuts Search And Replace just saved me loads of time when I moved a whole folder structure from one computer to another, leaving me with hundreds of shortcuts all pointing to the wrong place.

It was simple to use (the program is self-contained so there’s no installation required) and I found and replaced a matching pattern in the Target Paths of about 350 shortcuts in less than a minute - fantastic, and well worth my small donation which went winging it’s way back to the author once I’d tried it out.

In addition to replacing a matching pattern in the target path this program will also check for dead links - it found 8 “potential troubles” with my shortcuts and flagged them with a helpful yellow warning triangle in the search results preview (a useful break in the process) so I could skip them during the replace operation.

Just one tip: for quickest results run this program directly on the machine where your shortcuts are stored - it will still work across a network, but it works a lot slower that way.

During my search on how to do this I saw lot’s of people struggling to write complex scripts of their own to achieve the same thing, but look no further as this little tool gets my full seal of approval:

http://jacquelin.potier.free.fr/ShortcutsSearchAndReplace/

Screenshot:

Shortcuts Search And Replace Interface

How to add folder comments in Windows 7

Permalink: http://paul.us2uk.eu/?x=entry:entry151103-120033

Adding a description to a folder so you can easily see what that folder contains is one of the greatest features that Microsoft have left out. It was possible using Windows XP by using a 3rd party program called HobComment and there’s a bit more information about this in my earlier post on this subject here:

How to restore file tooltip popups in Windows 7

Sadly this doesn’t seem to work under Windows 7 but it can be used WITH Windows 7 - meaning that any comments created by HobComment can be viewed on ANY Windows 7 machine (they show up in the native Windows Explorer “Comments” field, if you choose to display that) - which is actually an improvement on XP as the only way to see those comments previously was by having HobComment installed on your machine: other network users couldn’t see them.

I have the option of either using an XP machine on my network, or Windows Virtual PC on my Win7 laptop (running virtual XP) and I have HobComment running there.

This is read from a Desktop.ini file which HobComment creates in the folder. I’ve tried just copying one of these to a new folder and editing it with a new folder description but that doesn’t work - I need to go into an XP machine running HobComment and confirm it there so it can do whatever magic it does to make it appear.

The text in the Desktop.ini file is simply 2 lines like this:

[.ShellClassInfo]
Infotip=YOUR FOLDER DESCRIPTION HERE

I’m sure someone out there must be able to glue all of this together somehow and make something similar to HobComment for Windows 7. Whoever you are “good luck, we’re all counting on you”!

How to migrate Windows user profile settings to another account

Permalink: http://paul.us2uk.eu/?x=entry:entry150607-000408

User Profile Wizard 3.9 by ForensiT is a simple to use tool to migrate your Windows user profile from one account to another. I used it on a computer with multiple accounts which I decided I just wanted one account left, but wanted to use all of the settings (desktop, programs list, etc.) from one of the other accounts. This program did the job - easily.

For more information and to download this great little program (the Personal Edition of User Profile Wizard is free to download) click below:

http://www.forensit.com/domain-migration.html

Avoid SPAM with my text to image conversion plugin for FlatPress

Permalink: http://paul.us2uk.eu/?x=entry:entry150530-064419

As one who knows just how easy it is to scrape web pages for email addresses it never ceases to amaze me how many people are unaware what they’re letting themselves in for by putting their email address on a web page.

I never do it myself but I was recently asked to do so by the owner of a new website I’m developing so I went looking for a way to help make those email addresses invisible to the kind of software programs I’ve used in the past, and found a simple text to image conversion script which displays an email address as an image, like this:

If you right click on the image above and inspect the image source address you’ll see that the email address itself is encoded so this will defeat most of the malicious robotic visitors to your site… though I’d still recommend that you NEVER put an email address on a web page, even like this, if you want to be 100% certain that your email address can’t be stolen and used in ways which could make your life a lot more difficult than it already might be.

As I develop most of my sites using FlatPress I wrote a neat little plugin to convert an email address to an image. This is how it works. [Read More…]

Computer bugs… everywhere!

Permalink: http://paul.us2uk.eu/?x=entry:entry150526-102839

Just like these:

http://www.whatsthatbug.com/2006/01/03/computer-loving-mites/

I added a comment there with my own plan to get rid of the little buggers (see copy below in case it never made it past the moderator) [Read More…]

Excel 2010 Solutions to the Clipboard Cannot Be Emptied Problem

Permalink: http://paul.us2uk.eu/?x=entry:entry150514-124113

In Excel 2010 you may run into an annoying problem trying to copy things to the clipboard:

clipboard-cannot-be-emptied

The solution which worked for me was to open the Windows Snipping tool:

Start > All Programs > Accessories > Snipping Tool

then click the “Options” button and uncheck “Always copy snips to the clipboard”, then close the Snipping Tool again.

Credit for this tip goes to user dawsopd at the MrExcel.com forum - you can also find a few other suggestions there if this doesn’t work for you:

http://www.mrexcel.com/forum/excel-questions/506582-excel-2010-pop-up-message-clipboard-cannot-emptied.html

Here are some other things you can try - I must admit that I still got the message occasionally after trying the fix I mentioned above, but the first solution on the following page (simply press the Esc key to deselect any cells which were already selected when you try to copy another cell) seemed to also work for me.

Fix for Cannont Empty the Clipboard in Office (yeah, I know it’s spelt wrong… but that’s how it is)

The save failed due to out of memory or disk space

Permalink: http://paul.us2uk.eu/?x=entry:entry150507-125645

For anyone who has a problem trying to save a Word 97-2003 Document (this may apply to other Office file types too) in Office 2010, specifically where you receive a message saying “The save failed due to out of memory or disk space” then there is an easy fix for this. [Read More…]

Pain is inevitable, but suffering is by choice

Permalink: http://paul.us2uk.eu/?x=entry:entry150410-110421

“Pain is inevitable, but suffering is by choice” said Debra Early, commenting after some 50 years of film and television history went up in smoke when fire ripped across the 7,000-acre Big Sky Movie Ranch north of Simi Valley, California, in 2003.

Stuff of dreams goes up in smoke at movie ranch

Only ashen timbers, charred metal and thousands of memories remain of old sets scattered around the hillsides that have been home to countless productions, from “Gunsmoke” to “Fear Factor.” Also lost was the original set used as Walnut Grove in the “Little House on the Prairie”.

Encephawhat?

Encephalitis - it really sucks.

Georgi says Hi!

If you found anything on this site of use, interesting, or even mildly amusing please consider tipping a few pennies in the jar to help look after Georgi, to whom this blog is shamelessly dedicated.

Georgi contracted encephalitis and fell into a coma in the summer of 2007. He’s a strong boy and survived, but he suffered brain damage and still can’t walk or talk (well, not very well - but he does try). He’s growing all the time and every penny we collect goes towards his upkeep, and towards his future care requirements.

visit Georgi’s blog
http://blog.georgi.co.uk/