View Single Post
 
Old 09-11-2019, 06:26 PM
Genericname1111 Genericname1111 is offline Windows 7 64bit Office 97-2003
Novice
 
Join Date: Aug 2019
Posts: 17
Genericname1111 is on a distinguished road
Default

Quote:
Originally Posted by kilroyscarnival View Post
I like the styles option for your future work.

This isn't an elegant solution, but depending on how much text you have, it may serve your purpose.

Copy your entire segment of text in Word and paste into an Excel worksheet. You may have to check that your defaults (from your last use of text-to-columns) is not going to automatically delineate by space or comma. Depending on your styles and formatting, it could drop the text into separate cells by paragraph.

Then insert a column to the left of all your text. Using the LEFT formula, you can ask it to return the leftmost, or first, character, in that cell to the right. (Example: "=LEFT(B2,1)" where B2 contains your first paragraph, and 1 is the number of characters you want it to return. You could then filter (and perhaps color code, to aid your at-a-glance review) for every Q and every A to make sure that they run in sequence. Filter the Q's and make the background yellow, and the A's blue, and when you unfilter you can see at a glance there should be a yellow/blue/yellow/blue pattern.

Or, for that matter, use Find/Replace in Word to replace every "Q:" with a "Q:" that is a larger font and bright red, and similarly for every "A:" or how you have it formatted, in green. It should be easier to eyeball down the pages, and at the end you can use your styles to reset the formatting back to normal.
Thank you, I don't have excel at work but the find replace option has proven quite effective.
Reply With Quote