This is an adaptation of an article posted on the Excel Esquire site. This scenario happens often in the middle of a litigation matter. Attorneys will make a list of relevant document numbers and only include the part of the number that is different. But in order for a paralegal or litigation support professional to run a search for the documents in a database, we need to re-format the document numbers.
For another example of concatenation, see my Fast Tip Friday tutorial entitled Batch Rename Using a Text File.
Source: Ben Kusmin Esq.