How to delete similar text in a word file?

June 25, 2011 at 04:09:33
Specs: Windows XP
I wanted to export my conversation out of Skype directly into a word document, but I think Skype does not have that function. Now, I simply copy-paste my chats into a word doc, but this is how it looks like:
[21/06/2011 16:10:42] A
[21/06/2011 16:34:32] B
[21/06/2011 16:34:51] C
[21/06/2011 16:34:52] D
[21/06/2011 16:34:56] E
[21/06/2011 16:35:10] F
[21/06/2011 16:35:14] G
[21/06/2011 16:35:18] H
[21/06/2011 16:35:23] I
[21/06/2011 16:35:25] J
[21/06/2011 16:35:27] K

I don't want the date and the time. Is there a way I can enter some 'formula' to delete the date and the different times altogether? Or do I have to go to each line and erase them? Please help!

See More: How to delete similar text in a word file?

June 25, 2011 at 05:26:52
How many characters are in each line of the conversation?

You could copy the data into Excel, use this formula to strip off the time and then Copy...PasteSpecial...Unformatted text the text back into Word:


The 256 represents the maximum number of characters that the formula will return.

If there are less than 256 characters in your string, it will simply return all of them.

If there are more, you can increase that number up to maximum number of characters allowed in an Excel cell, based on which version of Excel you are using.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question