Multi columns using delimeter

[ArnabSengupta]

Hi All,

I have a dataset in which "Order number" contains multiple orders separated by delimiter (//).the number of orders concatenated within "order number" column can vary from 1 to 99. I want to split based on the delimiter irrespective of the number of "orders" contained to the original column. It can be done by "Text to Column" tool but there are many issues with that. Is there a way i can use RegEx or any other tool?

I have attached a sample data set to it.

Thank you!

[Qiu · Accepted solution]

@ArnabSengupta 
Text to Columns and RegEx should do it.

[Qiu]

@ArnabSengupta 
Thank you for the mark!