You can try Data - Text to Columns - Delimited - / and you should be good
to go...
--
HTH...

Jim Thomlinson


"Bob" wrote:

I have a data in a A2:D2. The data in D2 is separated by / (book/boy/car).

I would like to separate the data into as many rows as there are "/".

the result would be A3:C3 repeated and D3book
A4:D4 with D4boy
A5:D5 with D5car