Hi there, first time posting.
I'm working at a place where I need to prepare a request list of serial numbers and submit it to a website.
The problem I'm having is that the request file I assemble comes with a 6 digit serial and the site I'm submitting it to requires the extended 8 digit serial. I've had to enter them manually, but I get 150-500 serials a day and that takes forever the way I'm doing it now.
The list has multiple types of serials, each starting with a different letter. The end 2 digits are dependent on the the first digit of the serial.
Now what I want to do is have an excell sheet that has a column I can paste the 6 digit serials into, and it would check the first digit of the serial to populate a second column with the 8 digit version assembled. So that way I can open the spreadsheet, drop the list in the first column, and then just copy the second column and go.
Bookmarks