Monday, 15 May 2017

Scam Alert - Fake Google Notify e-mail!

If you receive a message "Undeliverable messages" that appears to be from Google or GoogleNotify:
Do NOT click on any of the links in the e-mail!
Report it as spam and delete the message from your mailbox.

Here's an example I received recently:

Fake GoogleNotify message

It looks suspicious because of course I did not have a clue as to what this e-mail was about. Normally I don't receive messages like this from Google. The logo looks a little strange too.

I selected View Details (where the orange arrow is pointing above) to show me the details of the e-mail (this is a link in my Gmail e-mail software on my phone, therefore it is safe to use it - never click links within the e-mail).

Fake GoogleNotify message

In the above screen shot you can see it says the message is from someone at ""!!!! What's that? It's definitely not Google!

I searched for information about this and found this article:
As expected, it is definitely a malicious e-mail.

Be very careful with e-mails, even ones that look like they come from legitimate companies like Google. Read the message carefully before you click on anything! If the logo looks a bit strange, if the e-mail address it came from is not the usual (obviously someone from Google would have a Google e-mail address!), think about the message and whether it makes any sense. If you have any doubt, delete the message. It's also easy to search on the web for news articles about fake or phishing e-mails.

Take care!

Monday, 24 April 2017

Excel - date and time stamp keyboard shortcuts

There are many situations where it makes sense to enter a time stamp or today's date into your worksheet. Of course there are functions such as TODAY() and NOW() but these will recalculate automatically. If you want just to input a date or time, there's a couple of handy keyboard shortcuts you can use:

Press Ctrl-: (control and colon) to insert today's date.
Press Ctrl-; (control and semi-colon) to insert the current time.

NOTE: I've tested the above with Excel 2013 but it should work with other versions too.

Thursday, 13 April 2017

Excel - split e-mail addresses in one cell to separate rows

In Outlook if you copy e-mail addresses from the To or CC lines you end up with something like this:;;;

Paste the above into Excel and it's the same, all the addresses are in one line and in one cell. What if you'd prefer them in a vertical list like this:

In this article we'll go step-by-step through the process of splitting the addresses from one cell into many rows. 


Select the cell containing the e-mail addresses

Click Data | Text to Columns

Click Delimited

Click Next

Click Semicolon

Click Next

Each e-mail address will now appear in separate columns...

Select all the column cells of all the e-mail addresses (as shown above)

Press Ctrl-C to copy them

Click in a cell below (A6 in our example above)

Right click...

Click the Paste Transpose button (as shown above)

The addresses will now be listed on separate rows:

That's it!

Tidy Up
However, there's a space before some of them, if you want to tidy that up, use the Replace option as follows:

Click Home | Find & Select | Replace

In the 'Find what' box put a space, do not enter anything in the 'Replace with' box

Click Replace All

The following is the result:

I hope that was helpful. The above works fine in Excel 2013 but it's very likely to work in Excel 2010 and other versions too.