Separating naming conventions

[Analyst_Newbie]

Hello all,

I was wondering if you could help me separating naming conventions into multiple columns. Please refer to the figure below

In this example I wanted separate the product name (Column F) into multiple stages in order using the relationship "/" to trigger the next name convention to the next cell. I was wondering if anyone could help me on this?

Thanks in advance

 

[NARAYANK991]

Hi ,

Can you not use the Text to Columns facility in Excel ? Specify the slash character / as the delimiter.

Narayan

 

[mazamizo567]

Please Resend it into an excel Sheet and not a photo