![]() |
|
#6
|
||||
|
||||
|
In that case, you could use a series of fields coded as:
{=MOD(INT({MERGEFIELD Micr_Number}/1000),10) \# 0} {=MOD(INT({MERGEFIELD Micr_Number}/100),10) \# 0} {=MOD(INT({MERGEFIELD Micr_Number}/10),10) \# 0} {=MOD({MERGEFIELD Micr_Number},10) \# 0} etc., or: {=MOD(INT(«Micr_Number»/1000),10) \# 0} {=MOD(INT(«Micr_Number»/100),10) \# 0} {=MOD(INT(«Micr_Number»/10),10) \# 0} {=MOD(«Micr_Number»,10) \# 0} etc. to separate out the individual digits. Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| mergefields, table, word 19 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Field has multiple values how get those multiple values into one row | madiso10 | Excel | 1 | 06-02-2017 04:48 AM |
How do I mail merge records into table columns with more than one merge field?
|
tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
Excel / Mail Merge - Return Column Headers for All and Any Columns with Values
|
eduams | Mail Merge | 1 | 09-26-2016 07:02 PM |
| Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Summing up values in a Single Merge Field
|
Beowolf | Mail Merge | 1 | 03-07-2014 03:26 PM |