+ Reply to Thread
Results 1 to 3 of 3

Count words in multiple cells

  1. #1
    Registered User
    Join Date
    04-10-2011
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    1

    Count words in multiple cells

    Hello,

    I work as a wedding planner and sometimes people send me the names list and forget to count the people or simply miscount. Is there a way to count the names?

    For example, I would have in cell a1 trought a5:

    romeo and juliet
    brad and angelina
    ashton and demi
    bruce
    Chico, Harpo and Groucho

    The total at this table would be 10 persons.

    Is there a formula that counts words that have more that 3 letters?

    Thanks in advance

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Count words in multiple cells

    Hello & Welcome to the Board,

    Please take a few minutes and read the Forum Rules about cross posts.

    Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

    It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post
    HTH
    Regards, Jeff

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Count words in multiple cells

    Hi davidazevedo

    Welcome to the forum.

    What happens if we have

    Tom and Ann

    You would do best to post a sample workbook showing some typical entries.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1