title: Whatsapp .txt file chat into original whatsapp format
body: <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>