Word: Transpose SQL Dates

Today I worked out how to transpose SQL dates (copied from SQL Server) in Microsoft Word:

Bring up the Find and Replace dialog box. Enter the following:

Find what:

([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2}):([0-9]{2}).000

Replace with:


And enable “Use wildcards”

Word: Crop settings in 2007 and 2010

Yesterday I was trying to split an image into 9 separate parts using Microsoft Word 2010, so I could print them out, and when put together would be about the same size as an A2 piece of paper. But I just could not work it out!!!

In Word 2007, the settings were straight forward. Just specify the amount to crop from the left, right, top and/or bottom, and that’s it. But Word 2010 has “Offset X”, “Offset Y”, etc.

In the end, I uninstalled Office 2010, and went back to Office 2007.

Here are the settings in Word 2007:

Word 2007 Crop Settings

You will see that the height of the original image was 30.24cm, so I split this into three vertical measurements of 10.08cm.

The width of original image was 19.84cm, which I split into three horizontal measurements of 6.61cm

The image above shows the crop settings when doing the top left part. i.e. cropping 20.16cm from the bottom of the image, leaving 10.08cm of the top, and 13.22cm from the right of the image, leaving 6.62cm.

Continue reading