copying/moving a certain word to the next Col

**gencoglu27** · 03-11-2012, 02:54 AM

Hi,

I have a text in A1 and I want to click some words in the text to copy them to the next col(B)
I mean each word I click or select+enter should be listed in col B. I want only those which I clicked to be listed in
col B1,b2,b3....

Thanks a lot.

**davesexcel** · 03-11-2012, 02:46 PM

You may have to seperate the words.
The attached has three examples.

**gencoglu27** · 03-17-2012, 01:49 AM

Thank you Davesexcel, You are great.I asked the same question more than five forums.Nobody could answer.
You did a big favour to me.I think I will need some modification to make it more practical/functional.

Thanks..

**gencoglu27** · 03-17-2012, 02:38 AM

This idea occurred to me as I was reading an article on the internet.

There were some new vocabulary in the the article .Instead of copying and pasting each unknown word (it is hard and takes long time) and look them up, I decided to copy the whole text and paste it to an excel page and click the individual word to create a list then the "google-translate" do the taranslation.

.So far so good
However ,I would be nicer to click the words of the article on the internet and copy them directly to an excel page.

Is it possibele to click and send a word to an excel page directly from internet page ? Could you code/create such a macro ?

Thanks.