Creating a unique ID using the Concatenate function

I need to create unique IDs for all of my stock. I would like to use the concatenate function so that the first letter of each products type is taken and then joined onto a unique number. Im not sure how I will do this I was thinking that the formula looks at the largest value and adds 1 so that there are no duplicate numbers added to the first letter of the product type. E.g. the first mother board added will be "M1" the next will be "M2" as the formula has found that M1 exists and has added 1. If someone could help with this i would be very grateful thank you.

sounds simple enough, but we'd need to know a bit more info

your product codes are not going to be simplified down to just one character, e.g. your mother board will be M1, yes 'mother board' begins with 'M', but so does memory and mice

there is no problem with achieving what you want, apart from where you said -> "so that there are no duplicate numbers added to the first letter of the product type. "

you'll need an established list of product codes

sorry you didn't get the answer you were wanting, but I hope you understand that for us to be able to give you a solution that works for you, we'd need more detailed info of how you currently list your stock

Yeah I was just trying to use "M" for motherboard as an example but it would be great if the formula could take the M from mother and the B from board if that it possible. Also I was hoping that instead of an established list the formula used would look at the largest number used and then add 1 so that their will never be a duplicate number. If it is easier it can be more than 1 formula so that the unique number is worked out in a cell then in the product ID cells a formula such as

Please Login or Register  to view this content.