Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-09-2019, 09:53 AM
boonlailee boonlailee is offline Mergefield - Replace Prefix of Document Number Windows 10 Mergefield - Replace Prefix of Document Number Office 2019
Novice
Mergefield - Replace Prefix of Document Number
 
Join Date: Jun 2019
Posts: 6
boonlailee is on a distinguished road
Default Mergefield - Replace Prefix of Document Number

Hi, i need help on this:

Field Name: DocNumber

Sample of DocNumber (this is actually the invoice number):

INV-0001
INV-0002
INV-0003
INV-0004


I making use of this mergefield «DocNumber» to create my DeliveryOrder bearing SAME numbering, however i need it to be in different "Prefix" as per below:

DO-0001
DO-0002
DO-0003
DO-0004

Please help.
Thanks.



Boon Lai
Reply With Quote
 

Tags
merge field, merge fields



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 02:37 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