I've been emailing this around a few excel add-in sellers on the net, but I'm not sure it can be done. If not excel, would another programme do it? I know Regex language could do it.

I'm willing to pay for this customization if it can be done. Here is the email I sent around:


What I need is software to copy (not extract) text from excel cells and add
this text to another cell (the next column along). I need to be able to
enter the words which the software is to copy and paste.

Example:

*dog training is good
*cat was walking down the street
*parrot made a sound and ran away
*hamster ran away
*mouse made a squeaking sound
*gerbil ran under the floor without making a sound


Let's say I have the above text in each cell in excel.

Let's say I want to copy and paste the following words:

ran
sound

Excel then pastes these words in the next column in the same row in the same
order it finds them. It would do this:

*dog training is good
*cat was walking down the street
*parrot made a sound and ran away sound ran
*hamster ran away ran
*mouse made a squeaking sound sound
*gerbil ran under the floor without making a sound ran sound


Do you see what I mean?

Can this be done?