word count

  1. D

    Top Occuring Phrases/Words in a Column

    Hello, I have a very large database of items of different names and descriptions. Some items are similar to others (ie: cable type X, blue, 3ft or cable type X, green, 9ft, or heat shrink sleeve,clear,55cm or main wire assembly,mft,out) I have been browsing around online (including other...
  2. R

    Macro to count word counts in different Word docs, and enter them into Excel?

    Hi everyone, I'm an aspiring author, and want to keep track of the word counts in my chapters. At the moment each chapter is a different file. I would like a macro to go into each file, and tell me the word count in an excel table, for each chapter. I'm usually pretty good at figuring macros...
  3. T

    Word count Deadline

    https://drive.google.com/open?id=0B474It8rivBNMXYyWEI5U09TRHM Click the link to see the Workbook. I am trying to setup my word count log to have two-word count goals. One for the whole novel and one for weekly. I use two pie charts that fade away as I accomplish my goals. My issue is my weekly...
  4. victorcarreto

    finding pair of cells with different numbers of words

    Hello, I am dealing with texts, not numbers. Column A has a text in English, and column B a text in Portuguese. I need to find pairs of cells A1-B1 or A1234-B1234 whose number of words have a difference of 9 words minimum. For that I have this formula which I wrote on column C, to identify such...
  5. J

    Count 30 Characters and insert new row with no word slice

    Hello All; I have a macro requirement were the macro reads a text in a cell; copies the first 30 characters; inserts the test into a new row. The macro contiues were it left off reading the next 30 characetrs and inserting a 2nd row pasting the text. This process continues until there is no...
  6. F

    Counting word occurrences

    A1: Win */* Over * A2: Win */* Over * A3: Loss */* Under * A4: Win */* Push * A5: Win */* Over * A6: Win */* Over * A7: Win */* Over * A8: Win */* Under * A9: Loss */* Over * A10: Push */* Over * A11: Loss */* Over * I want to count how many times the word Over occurs and then count how many...
  7. W

    Formula: How-to: Count occurrence of verbiage & display verbiage?

    How would I look at a range of cells, let's say E10:E5000 and: 1- Count the occurrence of some words "sku1", "sku2", "sku3", "sku4" 2- Display that word, a space (or tab), and the count, newline for each word For count, I have "=COUNTIF(E10:E5000,"*sku123456*")" and that works for counting a...
  8. T

    New Excel User - Simple Word Count Tracker Help

    Hello all, This is probably a very simple challenge that I've run into, but I am a writer, and I am currently trying to create a spreadsheet that tracks how many words that I type daily. I am currently using Google Docs spreadsheet application online, but have access to Office 2007 on a...
  9. E

    Word Count

    Does any one have a formula that counts the number of words in a cell?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top