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.
*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:
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?