Macro to separate the string of texts (with line break) and paste them in every cells (2)

Hi all

This is a continued version of the previous request (1 column)

A special thanks to mr nilem and YasserKhalil for responding to my previous thread.

Initially, I thought of splitting up one column at a time but now I am wondering if there is a macro that can separate the string of texts (with line break) in the 2 columns and paste them in every cells.

There will be many rows (from row 2 to infinity) on a weekly basis.

Before.PNG After.PNG

Thank you for reading and thank you for you help

Hi Fantasylo,
try

Please Login or Register  to view this content.

Hi Richard Buttrey and nilem

Both codes work! Thank you for your help! It really means a lot to me.

Thanks and have a nice day!