+ 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 - RIP 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
    29,464

    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

    RIP - d. 06/10/2022

    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