|
|
#8
06-10-2019, 05:45 PM
|
|||
|
|||
Hi Paul,
thanks for your feedback, refer the attached. Page 1: Highlighted in Yellow, this is the original Invoice No based on <<DocNumber>> and required NO transformation. the result is INV-0001 (this one is totally fine). Page 2: Highlighted in Green, this is the DO No, to be based on <<DocNumber>> which required transformation we discussed above, the expected result should be DO-0001 and have yet to get the desired outcome. Thanks again. Boon Lai 
|
| 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 |
 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 |
|
Word 2007 TOC Section Number w/Alpha Prefix?
|
Gwen Butler | Office | 2 | 09-29-2011 06:10 AM |
|
Find & Replace words with "/" prefix & suffix
|
tollanarama | Word | 4 | 01-25-2011 02:19 AM |
Windows 10 
Office 2019
Threaded Mode