Mail Merge - Masking/Formatting

[MrBlack]

So I am not much of an office power user and never use mail merge but I have been asked by a colleague for some help on masking/formatting the output of some data in a mail merge.

I have searched on the internet and found some helpful examples but haven't found exactly what they need or have failed to understand how this is done in the examples I've seen on various pages.



Long story short is they have the following example data format:


Account number: 12345678
*Always 8 numbers in length*

Sort Code: 11-22-33
*Always 3 sets of double digit numbers separated by two hyphens*


They are only wanting to display/merge the first 4 digits of the "Account Number" and only display the last 2 digits of the "Sort Code".

I have found examples for showing the last 4 digits and tested this and got it working but I cannot see how you would go about doing the opposite:

//Example showing last 4 digits of "Account Number"
{ MERGEFIELD "Account_Number" \#\x###}

I've not found anything similar for showing the last two numbers of the "Sort Code" given the formatting of it with the hyphens.


If anyone could offer any advice or point me in the right direction (or website) that would be greatly appreciated.