Extracting parts of string seperated by "/" and copying them into adjacent rows

[yorkshirelad]

I have a large spreadsheet with a string in column A that I need to split into six parts. Each part is identified by a "/"

Example of the string : ID No / Item / Size / Colour / Comments / Type /

I need to extract each part of the string and copy it into adjacent cells in the same row

ID in column B,
Item in Column C
Size in Column D
Colour in Column E
Comments in Column F
Type in Column G

Many thanks for any assistance

 

[VoG]

Select column A, Data > Text to Columns, tick Delimited, click Next, tick Other and enter / then click Finish.

 

[yorkshirelad]

Doh...thanks Peter that's brilliant - I just didn't see that one