Finding and grouping cells with similar subject matter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveT - 18 Apr 2008 20:31 GMT

I have a .xls spreadsheet with several thousand client comments. I would
like to search specific key words/phrases that appear throughout the comments
to discover what they are saying collectively about our "customer service",
"payment plans", "support", etc.

I can use Edit--Find--All to get a pop up in which I can type a key
word/phrase and produce a list of the cells containing the key words/phrase I
am searching, and I can scroll through the list to see them one-by-one, but I
would like to export or group those specific cells with together into another
spreadsheet so I can work them separately as a subset with a common theme.
How can I do that???

Reply to this Message

Pete_UK - 19 Apr 2008 00:02 GMT

Have you tried using Autofilter? From the drop-down you can select
Custom and then you have options like "contains", or "begins with" and
you can enter a phrase.

You can then highlight the visible rows and copy just those to another
sheet, and repeat this for other phrases.

Hope this helps.

Pete

> I have a .xls spreadsheet with several thousand client comments. I would
> like to search specific key words/phrases that appear throughout the comments
[quoted text clipped - 7 lines]
> spreadsheet so I can work them separately as a subset with a common theme.
> How can I do that???

Reply to this Message