Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2020, 09:44 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

Even though if I have syntax error now values are returning.




I have 13 values which are coming from field,11 values are coming as expected but other two values are not populating ,its coming as -8 -8 . Do I need to make any change in formula ?

This is My Formula,

{=MOD(INT(«ACCOUNT_NUMBER»/100000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1000),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/100),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/10),10)\#0}
{=MOD(INT(«ACCOUNT_NUMBER»/1),10)\#0}

Received Output Value:
0 1 3 0 1 0 9 1 7 6 1 -8 -8 <<<<<like this

Expected Output Value:
130109176110

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 01:52 PM.


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