Splitting a Cell based on "/" and adding new Rows based on Part Number Logic

Dear Excel Users,

I have a situation where I have some Part Numbers mentioned in Column A separated by "/".

However I want only 1 Part number in 1 cell, and I want the remaining Part Numbers to be copied down to the below row with all the other details in Column B Through M remaining same.

However there are some details that need to be addressed while copying down. (Mentioned in Cell A25 of Attached Sheet)

Please see attached sheet for understanding.

I have 1000 such rows.

Help Appreciated.

has revision number always 2 digit ?
have all other numbers always 3 digit ?

Revision Number can be either 2 or 3 Digits..

Part Number will always be XXXX XXX XXX (In the attached case - 7325 014 811)

Please Login or Register  to view this content.

@jindon - The Code is working, however if the Revision Number is 3 Digits, it is not giving the desired output.

@patel45

Thank You,

The Code Worked perfectly..

@ jindon

Works!!

Thanks a Lot.. The Code was great!

@ Jindon & patel45

There is a problem.

The number of "/" may vary.

The macro is running fine if the number of "/" is 5.

The Macro is still not running perfectly as the raw data is derived from a Text file and may have some formatting issues.

I am attaching the original sheet for your reference.

Please provide a solution.

Yes its dirty.. I have downloaded that as a garb;ed Text File.. Sorry for the inconvenience though.

Where should I insert that line?

And also that last word of the code should be "Then" instead of "The" right?

Thank You.

The Code is amazing..