1. G

    Remove list of keywords in Sentence

    Hello, this has been asked before but my problem is a bit different. I want to get rid of some words in a column using a Macro (or formulae) text revised text Text to remove This is a sentence containing keywords. For Analysis, for general. sentence,keywords,analysis,general is this is a...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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?
  12. 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!!
  13. 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...
  14. 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...
  15. 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...
  16. 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.
  17. 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...
  18. 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
  19. 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
  20. 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...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back