I have two columns Column A and Column B Column A has all existing product codes Column B has all existing and new product categories
Old Product codes consists of two parts two letters and a 6-digit number the letters always remain the same ER the numbers were picked at random. So existing product codes are between ER000001 and ER999999
New product codes will follow a new pattern "ER" + Product Category + a number For example, if product category is 14 All the new product codes in this category should be ER140001 up to ER149999
I need a formula that will create new product codes but not use any of the old ones
I have tries a million things and I am afraid I cant find a solution.
<code>
</code>
Old Product codes consists of two parts two letters and a 6-digit number the letters always remain the same ER the numbers were picked at random. So existing product codes are between ER000001 and ER999999
New product codes will follow a new pattern "ER" + Product Category + a number For example, if product category is 14 All the new product codes in this category should be ER140001 up to ER149999
I need a formula that will create new product codes but not use any of the old ones
I have tries a million things and I am afraid I cant find a solution.
<code>
</code>