Whatsapp Chat separated into 2 columns.

[serge]

Hi everyone,

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 for any idea.
Serge.

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
2
3
4	[15:17, 6/13/2017] +1 (323) 855-9999: Hi Anieka, do you get this message ?																		Hi Anieka, do you get this message ?
5	[15:24, 6/13/2017] Soshanna 1: Hey yes									Hey yes
6	[15:26, 6/13/2017] +1 (323) 855-9999: Good																		Good
7	[15:27, 6/13/2017] +1 (323) 855-9999: Let me call you in like 10 mn is that ok																		Let me call you in like 10 mn is that ok
8	[15:27, 6/13/2017] Soshanna 1: Yes									Yes
9	[15:27, 6/13/2017] Soshanna 1: Wat ur name agsin									Wat ur name agsin
10	[15:27, 6/13/2017] Soshanna 1: Again									Again
11	[15:28, 6/13/2017] +1 (323) 855-9999: Serge																		Serge
12
Sheet

 

[serge]

Sorry it came out a bit weird but I hope you understand the idea of what I need ?
Thank you.
Serge.

 

[serge]

Does any body have and idea ?

 

[lrobbo314]

In Cell K4...

=IFERROR(IF(FIND("Soshanna",B4)>0,RIGHT(B4,LEN(B4)-FIND(":",B4,FIND(":",B4)+1)),""),"")

and in T4...

=IFERROR(IF(FIND("855-9999",B4)>0,RIGHT(B4,LEN(B4)-FIND(":",B4,FIND(":",B4)+1)),""),"")

and then drag the formulas down.

 

[lrobbo314]

You can use conditional formatting to make her column pink and yours green. Select her column, and on the Home tab, go to conditional formatting. Select 'Format only Cells that contain' and change the drop down that says 'Cell Value' to 'No Blanks' and choose a pink fill color.
Do the same with your column, only this time, select a green fill.

 

[Marcelo Branco]

Maybe something like this

Type in K3
Soshanna

Type in T3
(323) 855-9999

Formula in K4 copied down
=TRIM(IF(ISNUMBER(SEARCH(K$3,$B4)),MID($B4,SEARCH(":",$B4,SEARCH(K$3,$B4))+1,1000),""))

Then copy the formula in K4, paste in T4 and copy down

Hope this helps

M.

 

[serge]

lrobbo314 and Marcelo, Wow, Thank you to both of you, all the formulas works perfect, that's exactly what I needed, really helpful.

Thank you very guys, really appreciate it, it will be much easier to read now.
Serge.