+ Reply to Thread
Results 1 to 2 of 2

Randomly selecting words from text

  1. #1
    Registered User
    Join Date
    09-12-2016
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Randomly selecting words from text

    Hello,

    I have a big chunck of text of around 11,200 words that I want to cut down to around 6,000 words. I've uploaded the text onto excel, seperated each word into seperate cells and managed to get all the words into one column. I want to randomly pick out words from the text, so that only 6,000 words are randomly picked out of the 11,200 words. How should I do this exactly?

    Thanks

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,420

    Re: Randomly selecting words from text

    Hi,

    One way would be to put

    =RAND()

    in all cells in the column adjacent to your data.

    Then sort the two columns using the RAND column as the key then pick the first 6000 words.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using VBA code to randomly generate words without repetition
    By EngineeringGuRu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2014, 02:16 AM
  2. [SOLVED] Inserting words from a (predefined) set, randomly
    By NathanC in forum Excel General
    Replies: 5
    Last Post: 09-07-2012, 04:44 PM
  3. Randomly selecting number from a list of numbers
    By buckhunt122 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2011, 01:15 PM
  4. select words randomly.
    By coolhit in forum Excel General
    Replies: 2
    Last Post: 02-02-2011, 06:17 PM
  5. Randomly selecting items from list under certain conditions
    By Excelleration in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-07-2009, 04:48 PM
  6. randomly selecting a cell from a range
    By snuiter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2008, 12:35 AM
  7. Randomly Selecting a Value from a Range
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 10:59 AM

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