1. E

    Return Only Different Words In Sentence

    i have two columns and each column has a text sentence. I just need to create a third column that shows only the words that do not exist in both cells. Example; <tbody> If John wants to if john does john if he can might if he can wants to does he can might </tbody> kind thanks, Eddie
  2. B

    VBA to capitalize every proper word in a sentence

    Is there any way using VBA to capitalize every proper word in a sentence? For example for the sentence: Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and...
  3. P

    Duplicate Multiple Record Combine

    Hi, I am trying to combine duplicate records but keep the data. I will provide an example below. Current Data: Part# text ------------------------ Part1 Sentence 1 Part1 Sentence 2 Part1 Sentence 3 Desired Outcome: Part # text ------------------- Part1 Sentence 1...
  4. R

    Dynamic formula value as part of sentence

    Formula: =N24&TEXT($P$25,"+#.#,,;[Red]-#.#,") This formula is part of a sentence. I need the format of P25 to be +##.# or -##.# regardless of the value. Therefore I need a dynamic formula to factor it if the value is over or under 1,000,000. The current formula will work if my value is in...
  5. L

    Conditional Formatting Rules for variable messages

    Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G. Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to...
  6. I

    VBA: Delete duplicate sentence in each row cell in column B if found

    VBA: Delete the duplicate sentence in each row in column B if found. Only unique sentence is expected as result in respective row cell in column B.
  7. M

    Check singe value in Sentence and return corresponding value

    Hi Team, I'm trying to search list of words in sentence, If that word is found in sentence return the corresponded search value. Eg : <colgroup><col><col><col span="4"><col><col></colgroup><tbody> Col A ColB ColC Col G Col H password is not working 1 D1 Searching Words Display...
  8. K

    split and place specific word only

    I have a sentence in cell A1 that contains a few words, but I just want to take a specific word and put it in another cell, for example B1 and so on the sentence in cell A1 is as follows: Name: one; Class: A; Add: yes; Name: two; Class: B; Add: no; Name: three; Class: A; Add: no the results...
  9. R

    Find a word within a sentence

    Hello, I have a problem using VBA and I would really appreciate if someone could help. I am using the following code to find the word "house" in any cell within column "L", if the word "house" is found within a sentence in a cell within column L copy whatever is in columns A, L and BX and...
  10. R

    Show changes (Track Changes or similar) in a new cell

    A1 - original sentence B1 - edited sentence C1 - is there a way to show what has changed similar to track changes in this cell? A1 - My name is Chris B1 - My name is Dave C1 - My name is ChrisDave The word Chris would have a strike throguh it?
  11. B

    Search in String of Text to Find "June, 15, 2018"

    I have a sentence on Sheet1 in cell A1 that reads something like, "Andy went to the park on June 15, 2018 and he never came back". How can I use VBA to extract that date from the sentence and put the date in Cell A2 on Sheet1. Thanks!!
  12. S

    Splitting text in cells.

    Hi, I need a script that would break up a block of text in a cell at full stops, question marks, and exclamation marks, and create additional cells (not rows) shifting bottom cells down and inserting split sentences consecutively into created cells. So, for example, A1 Sentence 1. Sentence...
  13. S

    How to Concatenate Multiple Rows with Conditions?

    <tbody> Code No. Sr. No Customer Description List IF (code) IF (sr. no) sum Textjoin (Description) 1 1 ABC sentence x 1 1 2 1 2 2 EFH sentence x 1 1 2 2 3 sentence x 1 0 1 2 4 3 PQR sentence x 1 1 2 3 5 sentence x 1 0 1 3 6 sentence x 1 0 1 3 7 4 SYZ sentence x 1 1 2...
  14. P

    Formula to identify cells that have 7 numbers with a string

    Looking for help, suggestions for a formula that would identify cells that contain a string (text string, like a sentence) but within the sentence there is a grouping of 7 numbers together. ex: cell value: "this item is for john in the mail room, 1234567". the 7 numbers could be at any...
  15. G

    Add HTML code </li><li> to the end of each sentence in a cell with vba

    I have a cell that takes text from a series of cells and copies it into a new cell. Is there a way to add html code at the end of each sentence using VBA? Any suggestions appreciated.
  16. S

    Split sentence into 2 cells

    I got a cell with the text: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE EXAMPLE GO TO NEXT ROW How would I get excel to split the sentence above into 2 different cells A1 & A2, after the sentence exceeds 66 characters So that- A1: THIS IS AN EXAMPLE EXAMPLE EXAMPLE EXAMPLE...
  17. W

    Insert cell date into a sentence.

    Greetings, I'm trying to put a cell date into a sentence. But when I do, it isn't in date format. ="Blood Sugar Log From "&H15 Any ideas? Thanks for you time and effort. W. Kirk Crawford Tularosa, New Mexico
  18. W

    Insert Date into a sentence.

    Greetings, I need to put Today's Date into the middle of a sentence. Thanks for your time and help. W. Kirk Crawford Tularosa, New Mexcio
  19. S

    Extract 2 words right and 2 words left from a sentence of a cell

    Hi All, can any one please help me get the below result in excel ? Sentence : <tbody> Again, this company is the best and pioneer on the trend. This is the reason why I will recommend this company. </tbody> From the above sentence, if i find the word company, i need to extract 2 words...
  20. kelly mort

    Counting number of words in a sentence

    1. I am looking for a script to count the number of words in a sentence from a word file. 2. Also to count number of words in a given cell in Excel Thanks for your attention Kelly

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...