How to bulk remove minutes from text.

Copper Contributor

Hi 

I am trying to bulk remove timings ( i.e., 6:21 etc) from captions from a recording, example of a small section is copy pasted below. There about 20 pages of it! The times (shown on the left) are on the same row so I cannot separate them out.  At the moment I am deleting them one by one which is taking forever. Does anyone have any ideas how to bulk delete them?

Thanks. 

 

6:47

  • commercial offices, industrial warehouses, hospitals, okay.

6:53

  • Retail, leisure, all predominantly, if not totally using frame construction.

 

2 Replies

@Natnewb Use a Wildcard Find and replace to find

 

[0-9]{1,}:[0-9]{1,}^13

 

With nothing in the Replace with control

Doug_Robbins_Word_MVP_0-1709704707816.png

 

 

@Doug_Robbins_Word_MVP 

Thank you so much! It's worked. That's saved me an 2 hours at least.