I am tasked with renumbering certain documents based on their type. We have two types - 'H' and 'P'. If the document type is P, there is no modification required. But if it is H, modification is required. Tpe H has three segments all numerical and is without a suffix in some cases and has suffixes in the form of .x, -x and (x). Example:
The third segment and/or suffixes could be 2 digits. Refer S.No 7 & 8 in the picture below:
The text strings following the number segments are of varying length.
Currently I am doing this manually, but itt is extremely tedious and I have thousands of documents to complete. I have broken my head trying formulas and have been unsuccessful. Will be grateful if someone can help me. I don't know VBA but a willing to learn
The requirements are:
1. For H Type documents all number segments should be prefixed with zero numeral except where there are two digits. See "Modified Number" column S.No 7 & 8
2. No change for P Type documents.
I am attaching the Excel file from which I made the image in this message.