Forum Discussion
Need help to cut out repetitive formating in Word to then copy and paste into Excel
- Lenka_KerumovaJun 21, 2021Iron Contributor
Hello rom915,
this is quite a process.
I think you might benefit from recording the repetitive actions. Record the repetitive action as a macro, assign a key shortcut and run when you need it without the bother of always going through the set-up (delete spaces between words, commas with paragraph marks etc.)
On the concrete note:
- To delete the time stamp, use wildcards. Too long to explain, so I will refer you to an article that helped me a lot when I did something similar to you: Finding and replacing characters using wildcards (wordmvp.com). This is an article that describes how to use wildcard in Word: How to Use Wildcards When Searching in Word 2016 (howtogeek.com). In the time stamp you need to work with the semicolon too to make a difference between any number and the timestamps.
- To join truncated sentences, I found it best to do it in blocks, running a macro that replaces the extra paragraph marks. Finding ^p replacing nothing, or if it is a line break, finding ^l. You might be happy with your Replace all, though.
- If you truly want each sentence on a new line, this is easy: Find ". " (fullstop and a space), Replace ".^p" (full stop and a paragraph mark). To delete an empty line, also easy: Find "^p^p", Replace "^p". Finds two paragraph marks, replaces with one, ergo deleting the empty paragraph.
You seem to know what you are doing, you just need some finesse. I did a similar work to yours, and recording these steps helped me save a huge amount of mental energy. And time as well.
Hope this helps. Lenka- rom915Jun 21, 2021Copper ContributorFantastic and thank you very much for your help Lenka. I will try and get my head around all this during the course of the day as see if I can get all this to work. If I need any further help I will get back to you. Thank you again and have a great day!
- rom915Jun 21, 2021Copper ContributorHi Lenka, just a quick update. Yes, managed to get everything to work as you suggested. Again, thank you very much for your help.
Cheers!