How to separate cell values and insert into new rows

[dj7616]

Hi all,
I am looking for a macro to look at a colum with a cell that has values that are separated by a comma or a space or a carriage return and make new rows with only a single value for that column of cells. I am sorry that sounds confusing but I have attached a sample worksheet. In the worksheet, I am looking at Column B and want to separate them into different lines but copy Column A and Column C for the new line. So I did the first one, which is row 2 was separated to row 3 and row 4. Any help on this would be great.

[tehneXus]

Hi,

click the button on the first sheet and check result on 2nd sheet: test_multiple_cells.xlsm


contains:

Please Login or Register  to view this content.

[scott.s.fower]

this works based on your test_multiple_cells.xlsx
run this macro

Please Login or Register  to view this content.

[dj7616]

Thanks guys,
Both work well, but I like Scott's since it fixes it on the same sheet. But both were awesome. Much thanks!!