Hello all,

I have a special request and not sure if it's possible, but I need to ask ?

I copied and past on excel all my chat from my futur wife and I would like to look pretty much how it look on my phone, so all the texts start in B4 and goes down to right now 20,000 rows.

How can I separate my text from her text like here, she is in column K and I'm in column T and removing the date and time, just keeping the conversation separate in 2 columns ?

Also could the text cells be highlighted in pink for her and Green for me ? and keeping the source texts in column B.

And if the text is to long that it will collapses into multiple rows ?

Is this possible ?

Thank you

I did not find the right solution from the internet
References :

  https://www.mrexcel.com/forum/excel-questions/1042318-whatsapp-chat-separated-into-2-columns.html