Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Mergefield - Replace Prefix of Document Number
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 06-10-2019, 08:48 PM
gmayor's Avatar
gmayor gmayor is offline Mergefield - Replace Prefix of Document Number Windows 10 Mergefield - Replace Prefix of Document Number Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
If the data contains INV-0001 (or INV-1) then the switch \# "0000" will produce
-0001. You can add INV or DO to this, as a prefix, as appropriate.

DO{ MERGEFIELD DocNumber \#"0000" }
or
INV{ MERGEFIELD DocNumber \#"0000" }
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Tags
merge field, merge fields

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to populate column with text prefix then next number (ascending) SerenityNetworks Excel 4 02-05-2019 07:22 AM
Mergefield - Replace Prefix of Document Number Replace characters in mergefield tommatwalker Mail Merge 6 07-17-2018 12:30 AM
Find entries lacking prefix and then add prefix. gsteel Excel 2 08-28-2017 11:36 AM
Mergefield - Replace Prefix of Document Number Word 2007 TOC Section Number w/Alpha Prefix? Gwen Butler Office 2 09-29-2011 06:10 AM
Mergefield - Replace Prefix of Document Number Find & Replace words with "/" prefix & suffix tollanarama Word 4 01-25-2011 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:54 PM.

Contact Us - Privacy Statement - Top

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