We receive weekly reports listing changes. Column A contains ID #'s. For our purposes, we would like to modify the ID number as follows:
Add a two-character alpha prefix: WO
Truncate the year from 4-digits to 2-digits
Reduce the number of digits following the dash from 7 digits to the last 5 digits
Example of original ID: 2015-0000247
Example of modified ID: WO 15-00247
I've attached a sample spreadsheet.