Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2020, 02:20 PM
macropod's Avatar
macropod macropod is offline How to Split Dynamic merge field values to multiple columns Windows 7 64bit How to Split Dynamic merge field values to multiple columns Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #2  
Old 01-30-2020, 05:22 AM
Naveen Dhanaraj Naveen Dhanaraj is offline How to Split Dynamic merge field values to multiple columns Windows 10 How to Split Dynamic merge field values to multiple columns Office 2019
Novice
How to Split Dynamic merge field values to multiple columns
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

Im getting syntax error, Could you correct me where Im going wrong?


!Syntax Error, «


Formula:
{=MOD(INT(«PAYMENT_REFERENCE»/1000),10) \# 0}


Thanks,
Naveen
Reply With Quote
Reply

Tags
mergefields, table, word 19



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 to Split Dynamic merge field values to multiple columns 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
How to Split Dynamic merge field values to multiple columns 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
How to Split Dynamic merge field values to multiple columns Summing up values in a Single Merge Field Beowolf Mail Merge 1 03-07-2014 03:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft