simplest way to do a selection on word table/database?

P

peter

I was given a word table/database with fields like name, hobbies, ...
Each row represents one person. The list contains a few hundred people.

Each name cell contain only one line/value.
Each hobbies cells can contain more than one line/value, and they are not
sorted in any orders within the cell. E.g. one person's hobbies cell may
contain "tennis", swimming", and another one may have "swimming", "tennis".
(the actual separator are line breaks not commas)

What's the easiest way to reduce this list to only the people whose hobbies
include "tennis"?

I also have Excel, if it is necessary to move the table into excel. However,
cells with multiple values/lines don't import very well into excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Adding a big matrix in Word 2013 5
Can table cells shading be conditional on data in a merge database 2
Odd style in table? 1
Building a table from a list on another worksheet 3
Pasting in Word Table 1
How to convert a huge table in MS word to MS excel 1
Parse a column using a VLOOKUP Table and post a result to another cell/column 3

Top