I am new to VBA. I want a VBA code that will pick particular words from one or more sentences and place them in adjacent cells.

Eg) if i have the following sentence in cell A1 'I like coding in Excel VBA' and following sentence in cell A2 'I am working on a Project'
I am looking for a code that will pick the word 'Excel' from the first sentence and place it in cell B1 and pick the word 'Project' from the 2nd sentence and place it in cell B2. Please help.

This should be in the Excel Programming forum. But just out of curiosity, why those particular words? That is, is it picking words by position, length, capitalization or what?

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.

Attached Files

Book1.xlsx (9.8 KB, 9 views)