Excel Magic Trick #18: Randomly Generate Letters

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
10,666
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Mar 5, 2008

See how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See how to randomly create letter sequences.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Hi, Really nice video.

    question: How do I ensure that there are no repeats? : I need a 4 letter word generated specifically need to randomize ABCD but they should not have any repeat characters.

  • Search for and then watch this video title:

    excelisfun Search for Excel Videos, Playlists & Download Workbooks

    This video will teach you how to find 'playlists'.

    I have a whole playlist filled with randomizing tricks, including how to ensure no repeats.

Video Responses

see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • Hahah voice reminds me of sesame street. Great job, thanks.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more