Need help to create a new line for cell content after comma

[renanpoco]

I need to do that so I can bulk add those words into a free course that I'm creating at Memrise.

This is what i have:
https://www.dropbox.com/s/ypb2r40hgyita96/Photo 04-11-18 02 35 23.png?dl=0


And this is what I expect do do for every case into the spreadsheet:
https://www.dropbox.com/s/pv0xkxd8xyj3ia8/Photo 04-11-18 02 39 57.png?dl=0


Basically I need to create another line to accommodate the content after comma. Is that possible ?

This is the .XLS file in which I intent to do that:
https://www.dropbox.com/s/1egmr3seq0u5gov/memrise english copy.xlsx?dl=0

Thanks

 

[Michael M]

Duplicate

https://www.mrexcel.com/forum/excel...ormula-remove-text-outside-parenthesis-2.html

 

[renanpoco]

Duplicate

https://www.mrexcel.com/forum/excel...ormula-remove-text-outside-parenthesis-2.html

Sorry, I don't know not even from where I do need do start to create a VBA solution for that. There is some option for a paid add-on or something like that ? Thanks.

 

[Macropod]

renanpoco: As per forum rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), kindly don't post questions about the same issue in multiple threads.

Thread closed. You may continue the discussion in your other thread.