View Single Post
 
Old 04-29-2020, 05:07 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If using Wildcards are not your thing, you can also do most of this by selecting it all and converting to a 2 column table separated by paragraphs. This will give you a column containing the time stamps and a second column containing the text. Then select the text column, copy it and use Paste Special to paste as Text Only to get just that text in consecutive paragraphs.

The final step would be to use Find and Replace to replace a paragraph mark '^p' with a space.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote