Posts by fatmcgav

    Re: Word Mmerge Field Format


    Quote from PeteNZ

    Hi Gavin


    How about trying to get the data you want via excel first, i.e. add a column to your spreadsheet and use the formula as shown below, i.e. your data is in A1 and you want to show just the last 8 characters in B1. You can then refer to column B for your mailmerge.

    Code
    =RIGHT(A1,8)


    Cheers
    Pete


    I spose that is one option Pete, however it just complicates the worksheet a bit more.


    Is there no easy way to do it at the Word end then?


    Cheers
    Gavin

    Hi there,


    I'm having some issues formatting a mail merge field in Word 2003.


    Using an Excel spreadsheet as datasource. The data in the field in question looks like this:

    Code
    633597032004B7

    I want just the last 8 characters.
    Now i tried using

    Code
    { MERGEFIELD ISAM_ID_633597 \# "x#######" }


    However the field then comes out as "97032004" - dropping the B7...


    Is there just a universal character option? I've tried replacing with *, @, % and cant get any to work...


    Any ideas?


    Cheers
    Gavin