You are reading a single comment by @cyberyark and its replies. Click here to read the full conversation.
  • I would paste it into excel as is and work some logic around ctrl h replacing and text to columns with a bit of doodling to create the rangers - 19 - 23 before a vlookip (perhpas not necessary) to post in the letters back to the numbers.

    Back at uni i'm sure i could run some sed scripts over the top of that to sort it out in unix in about 20mins.

    edit

    Fuck it, I'll just ask them to redo the source data for me.

    Spoken like a true business user. >

About

Avatar for cyberyark @cyberyark started