+ Reply to Thread
Results 1 to 4 of 4

copying/moving a certain word to the next Col

  1. #1
    Registered User
    Join Date
    07-10-2007
    Location
    Turkey-Bartın/
    MS-Off Ver
    Ms Office-2007
    Posts
    44

    copying/moving a certain word to the next Col

    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.
    Attached Files Attached Files
    Last edited by gencoglu27; 03-11-2012 at 02:59 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,485

    Seperate words in a string

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

  3. #3
    Registered User
    Join Date
    07-10-2007
    Location
    Turkey-Bartın/
    MS-Off Ver
    Ms Office-2007
    Posts
    44

    Re: copying/moving a certain word to the next Col

    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..

  4. #4
    Registered User
    Join Date
    07-10-2007
    Location
    Turkey-Bartın/
    MS-Off Ver
    Ms Office-2007
    Posts
    44

    Lightbulb Re: copying/moving a certain word to the next Col

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1