Word Mmerge Field Format

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:

633597032004B7

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

{ 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

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