Transferring Data from a Word Table and into Excel
Data is in tables in Microsoft Word and needs to be moved over to Excel–and retain the table structure.
PROBLEM: copy from Word and into Excel creates a mess. Items that were in the same cell in Word are in different cells in Excel.
The solution is to replace ^p in the document with something that can be used as a delimiter in Excel.
Notice in the video I used zzzz and then changed to a double-pipe as a delimiter. I could have used the double-pipe first, but it’s something I figured out during the editing of this video.
I had tried ** as a delimiter and that caused problems as I eventually realized that asterisks are seen as wildcards and aren’t good as delimiters if you’re going to apply Find/Replace.
My book: Guerrilla Data Analysis 2nd Edition
My blog: http://datascopic.net/blog-2-2