I'm working on improving invoicing for a company I work with, and I'm trying to make their Word tables more practical for my use in Excel. I want to create a template in Word that will be easily pasted into Excel (and then importable into my own database).
Below is what I've created in Word:
Which works unless someone uses returns/paragraph breaks (which they are wont to do, especially with addresses). Below is what it looks like when I paste the above into Excel:
This makes the table totally unsortable without a lot of processing. I'd love to be able to sort by name. Is there a way to prevent cells from creating new rows in a Word table when there are line breaks? Maybe a way to force only one line of text per cell (that would be wrapped within the cell)?
Thanks!