Excel Prefixed IDs & Content
Budget: $15 – $25 USD
I need a clean Excel workbook that does two things:
1. Column A must generate sequential document numbers in the exact format DOC001, DOC002, DOC003 … and keep counting upward as new rows are added. The “DOC” prefix is mandatory, and the numeric part should always keep the same width with leading zeros so the list sorts correctly.
2. Column B will hold the full body of each record and that text may include a mix of plain sentences and raw HTML snippets (e.g., `<p>`, `<strong>`, links). Whatever solution you build has to preserve every character exactly as typed—no stripping of tags, no unintended formatting.
A simple formula is fine if it will survive row insertions and deletions; otherwise, a lightweight VBA routine is acceptable. Either way, the numbering must automatically resequence when rows move around, and it has to keep working without any manual tweaks.
Deliverable
• An .xlsx file (macro-enabled if you choose VBA) with the above logic in place
• A short note explaining how to add more rows and keep the numbering intact
No additional layout, colors, or extras are required—just a dependable sheet that handles the DOC-prefixed IDs and mixed-content column exactly as described.
1. Column A must generate sequential document numbers in the exact format DOC001, DOC002, DOC003 … and keep counting upward as new rows are added. The “DOC” prefix is mandatory, and the numeric part should always keep the same width with leading zeros so the list sorts correctly.
2. Column B will hold the full body of each record and that text may include a mix of plain sentences and raw HTML snippets (e.g., `<p>`, `<strong>`, links). Whatever solution you build has to preserve every character exactly as typed—no stripping of tags, no unintended formatting.
A simple formula is fine if it will survive row insertions and deletions; otherwise, a lightweight VBA routine is acceptable. Either way, the numbering must automatically resequence when rows move around, and it has to keep working without any manual tweaks.
Deliverable
• An .xlsx file (macro-enabled if you choose VBA) with the above logic in place
• A short note explaining how to add more rows and keep the numbering intact
No additional layout, colors, or extras are required—just a dependable sheet that handles the DOC-prefixed IDs and mixed-content column exactly as described.