Find a theme in a article in a single cell

  • Thread starter Thread starter Prashanth KR
  • Start date Start date
P

Prashanth KR

Hi,

I want to automate a process in which Iam looking out for a theme in an
article which is placed in a single cell A1. (The article may have more than
200 words).

For eg. the actual message in an article may have "Patients with Aortic
Stenosis benefit from lipid-lowering therapy with Vytorin".

The problem is, the words may not be in the same order or having the same
spellings or synonyms. But the message in the article will say that.

Kindly, give me some inputs or any other idea so that I can capture it
without really reading the whole article.

Here's hoping for a positive reply.

Warm regards,
Prashanth KR.
 
How would excel differentiate that from any other statement? Is the data that
is put into a cell just text? or are their other 'hidden' characters as well?
Is the 'theme' always at the same place in the article(s)? Do these articles
have any kind of essential theme setup, i.e.: would Patients or benefit or
therapy be key words that may indicate they are in a theme sentence?
 
Back
Top