Whatsapp .txt file chat into original whatsapp format
<p>I have whatsapp chats in .txt file format. I want it to convert to original whatsapp format (i.e whatsapp original interface). 
<strong>The input is .txt file</strong></p>

<p>Example:</p>

<pre><code>12/11/2014, 12:22 PM - John: Hi Stacy
12/11/2014, 12:22 PM - John: :)
13/11/2014, 2:59 AM - John: How are you?
13/11/2014, 2:59 AM - John: Are u home?
13/11/2014, 8:09 AM - Stacy: Hi John
13/11/2014, 8:10 AM - Stacy: yeah I am good
13/11/2014, 8:10 AM - Stacy: and home too
13/11/2014, 9:14 PM - John: ok
16/11/2014, 4:14 PM - Stacy: how are you?
16/11/2014, 4:16 PM - John: I am good too
16/11/2014, 4:16 PM - John: See u tmrw at work
16/11/2014, 4:16 PM - John: :)
16/11/2014, 4:24 PM - Stacy: yeah ok
</code></pre>

<p>Now, I want the output in a Word doc with a similar interface as that of whatsapp.</p>

<p>[i.e., all chats by John on left side and by Stacy on right side]</p>

<p>I tried to do that by importing this .txt file into excel and then editing in word. But that didn't work. </p>

<p><strong>Required output format:</strong></p>

<p><a href="http://i.stack.imgur.com/vYe3E.png" rel="nofollow">Please click here to view the required output word format</a>
(Its very similar to whatsapp format)</p>

<p><strong>This is what I did:</strong> </p>

<p>1) I imported the data in excel from .txt file.</p>

<p>2) I used python code to convert that txt format to excel file
<a href="http://i.stack.imgur.com/8FPaj.png" rel="nofollow">Please click here to view that file</a></p>

<p>3) I then copied this to .doc file and added borders</p>

<p>4) And now I removed output border. That's how I got the format I attached in the first link.</p>

<p>The problem that I am facing is wherever the text is not there, I need to manually go that cell and select "No Border". I am having 1000's of these. </p>

<p>Is there anyway I can do this programmatically?</p>

<p>Can something be done using Word or Excel VBA?</p>