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:
I want just the last 8 characters.
Now i tried using
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...