Client has Items in the format of XX/XXXXXXXXXXXXXX (2 segments, 2 & 14 characters).
The Items are entered in various lengths.
Some of the Items may appear with as few a 5 characters total (e.g. AP/W20), while others will be longer, up to using the full length (e.g. AP/12345678901234).

We have created a Gridview that reports details on the Items. We send this View as a spreadsheet to their Supplier.
So far, no problem.

Here is the issue:
The Supplier wants us to generate the spreadsheet so that the column with the Item number will always be 26 characters long (for whatever reason).

How do we do this?