Thread: [Solved] VBA code to select one word from a text in a cell and place that word in next cell
View Single Post
 
Old 05-01-2014, 12:33 AM
Shinaj Shinaj is offline Windows Vista Office 2010 32bit
Novice
  
Join Date: May 2014
Posts: 3
Shinaj is on a distinguished road
Default VBA code to select one word from a text in a cell and place that word in next cell
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.
Reply With Quote