It needs to pick the word by its look not by position, length etc..
I have uploaded a speadsheet that has an example. I need to search words like red, Blue, Marble, Sunday from the sentences mentioned in column B and if any word is present in any of these sentences then that word should appear against that sentence in column C, as mentioned in the attached file.
I found only conditional formatting option in Excel programming forum but no VBA code. Conditional formatting only highlights the work, it doesnt pick it and place in the adjacent cell.
|