+ Reply to Thread
Results 1 to 8 of 8

BEST Formula For Meta Keywords???

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    43

    Question BEST Formula For Meta Keywords???

    I need a formula for excel that takes all the words that are in a specified cell, finds the most important words in that paragraph and puts it in a diffrent cell, making them comma delimited. I have been playing with some formulas in excel and I can't find the right one to do this. If anyone has any ideas for a solution, it would be GREAT! :D

    Sample of what I need it to do:

    Description One day there were three cats. A white cat, a black cat, and a brown cat. The white cat said "I'm bored. I don't have anyone to play with." The black cat said "I'm bored. I don't have anyone to play with." The brown cat said "I'm bored. I don't have anyone to play with." So they decided to meet at the park. When they got there, they didn't know what to do. The brown cat wanted to roll in the mud, but the black cat wanted to roll in some coal, but the white cat wanted to chase birds. So they had to agree on something. So they agreed to go for a walk. On their way walk they saw a man fixing the phone wires, a man fixing the road, and a man painting his house green. So they stopped walking and started watching him. When he went in to have lunch they knocked over all the paint right on them.
    Keywords cats, fixing, mud, coal, birds, man, phone, road, house, lunch, paint

    Oh and it cant be more then 11 keywords!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: BEST Formula For Meta Keywords???

    What makes those the key words?

    Why isn't cat (singular) a key word?

    Excel doesn't do lexical analysis.
    Last edited by shg; 07-31-2013 at 06:44 PM.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    43

    Re: BEST Formula For Meta Keywords???

    Well I felt that those were the keywords relevant to the story. And okay, where would I turn to tackle such a problem, if its not doable. Maybe Microsoft word has such a feature?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: BEST Formula For Meta Keywords???

    There is no such feature in any program I know of. Well, maybe Watson could do it, but I don't know if its sense of relevance would agree with yours.

  5. #5
    Registered User
    Join Date
    11-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    43

    Re: BEST Formula For Meta Keywords???

    Quote Originally Posted by shg View Post
    There is no such feature in any program I know of. Well, maybe Watson could do it, but I don't know if its sense of relevance would agree with yours.
    Are you saying there is no way to automatically generate a meta description or meta keywords of some kind of document?

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: BEST Formula For Meta Keywords???

    No, I'm saying no tool I know of does it, whatever "it" is. There are many tools I know nothing about.

    I don't understand your use of "meta" -- it's not data about the data, it's portions of the data (nouns) that you appear to be trying to extract.

  7. #7
    Registered User
    Join Date
    11-21-2012
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    43

    Re: BEST Formula For Meta Keywords???

    Quote Originally Posted by shg View Post
    No, I'm saying no tool I know of does it, whatever "it" is. There are many tools I know nothing about.

    I don't understand your use of "meta" -- it's not data about the data, it's portions of the data (nouns) that you appear to be trying to extract.
    I'm talking about meta keywords, meta description. Like the ones that SE's use to optimize if your website is suited to be a certain web rank. I just have many different descriptions and I need a formula to find those meta keywords and/or to generate a meta description from the description provided.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: BEST Formula For Meta Keywords???

    Then maybe you should be looking at SEO tools. Dunno, good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF formula that checks several values and several keywords
    By vlife in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-01-2013, 11:40 AM
  2. Search formula referencing range of keywords
    By Malvaro in forum Excel General
    Replies: 2
    Last Post: 07-01-2008, 05:01 PM
  3. Getting Meta Tags,
    By ezykiwi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2006, 01:06 AM
  4. META in excel publishing
    By bjenkins in forum Excel General
    Replies: 1
    Last Post: 11-21-2005, 09:00 PM
  5. can i make a formula to search keywords in a excel workbook?
    By gorillayam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2005, 11:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1