Creating Uniform Product Numbers With Data From Other Cells

[AndianAtWork]

I'm drawing a bit of a blank on how to go about doing this. The current product numbers for the list I'm updating are in a format that look like this:

Product Number: [A2]
ADV1-ADV5.1-19-8.5

Product Title: [S2]
ADV.1 One Piece ADV5.1 Forged Wheel 20x8.5.5

But unfortunately for me, none of the new products come with product numbers, so I have to generate them myself.

So the product number is using the Manufacturer name (ADV.1), the wheel name (ADV5.1), and the wheel size.

All of the product titles are in the same format with names first and the wheel size at the very end. They need to be 20 characters or less.
Some of the product titles will be shorter.
For example:


ADV.1 Three Piece ADV5 Standard Concave Wheel 18

ADV.1 Three Piece ADV5SL Wheel 19

ADV.1 Three Piece ADV5SF S Function Wheel 19

ADV.1 One Piece ADV5.1SL Mid Profile Wheel 19x10

ADV.1 One Piece ADV5.1SL Deep Profile Wheel 19x13

ADV.1 One Piece ADV05.1 Flat Profile Wheel 22x9

If anyone can assist me with finding a way to generate product numbers, it would be greatly appreciated. Thank you :]

[dilipandey]

Hi Andian,

You can use RandBetween function here... for example

Manufacturer name (ADV.1), the wheel name (ADV5.1), and the wheel size, Randbetween function

here Randbetween can use number brackets as per manufacturer / wheel name / wheel size e.g., manufacturer A will be Randbetween(100,999) and manufacturer B can be Randbetween(1000,1999).. and so on which you need to smartly work upon as per your products. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

[AndianAtWork]

I'm sorry I didn't see your reply sooner. I had left the office. I'll give it a go and let you know the results momentarily. Thank you very much!

It worked wonderfully. Thank you once again.

[dilipandey]

Okay... no problem

awaiting to know if that worked for you.


Regards,
DILIPandey
<click on below * if this helps>