Hi Everyone,



Please find attached excel sheet. In column A there are few values. some of the cells have multiple values. I want to split such values.
But challenge is I dont want to split value and paste in next column(the way we do in Text to Column). I what i want is if there are 3 vales in cell A1(Split by alt+entre) then code should add 2 more rows below that and paste 2 vales in those two rows.

If its confusing, please refer to my sheet. In cell A1, there are 3 values Alex, Smith and peter. What I want is it should i deally add 2 more rows below A1 and pase smith and peter respectively in it.

Thanks

Attached Files

Book2.xlsx (8.6 KB, 12 views)