Results 1 to 7 of 7

Formula to Count Occurences of a Word in a Sentence Within a Cell

Threaded View

  1. 11-11-2009, 07:58 AM #1
    R_S_6
    R_S_6 is offline
    Forum Contributor
    Join Date
    07-28-2008
    Location
    Leamington Spa, UK
    MS-Off Ver
    2010
    Posts
    142

    Question Formula to Count Occurences of a Word in a Sentence Within a Cell

    Hi All,

    I am after the formula to count the occurrence of, for instance the word 'the' in a sentence/paragraph that is contained in Cell A1. Cell B1 should return the quantity of times the word 'the' has been found in Cell A1.
    Thanks in Advance,

    Cheers,
    Mark
    Last edited by R_S_6; 11-11-2009 at 09:00 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1