Need help making a manipulator tool

[rungok]

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.

[JBeaucaire]

Sounds fine. So, post up a workbook with a complete set of BEFORE/AFTER examples of all the serial number conversions you need in your new formula, we can help from there.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

[rungok]

I'm not really allowed to put up the actual serial numbers, but I can put up examples of them.

It's pretty simple. Just need to be able to take a precomposed list of serials, which are mixed up with each other, and have it tag them with the correct end digits and put them in a new column so I can copy/paste from there.

Most of the serials have a beginning that's 2 digits that matches the last 2 digit cap.
However some of them start with just a single tag and have a 2 digit cap on them.

[JBeaucaire]

Well, after asking for a complete set of examples you provided 3, so I'll presume they demonstrate fully your need.

Put this formula in C2 and copy down:

=A2&LEFT(A2,2)