Scribd
Upload
61 views2 pages

Excel Random Text & Password Guide

This document discusses how to generate random text strings and passwords in Excel using RANDBETWEEN and CHAR functions. It provides an example formula that concatenates four random number and character functions to generate 4-character passwords like "4Np#" or "2Yu&". The functions return random numbers from 0-9, uppercase letters A-Z, lowercase letters a-z, and special characters. Understanding how to use Excel functions to generate random values can help when creating lists, simulations, or passwords.

Uploaded by

lechu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views2 pages

Excel Random Text & Password Guide

This document discusses how to generate random text strings and passwords in Excel using RANDBETWEEN and CHAR functions. It provides an example formula that concatenates four random number and character functions to generate 4-character passwords like "4Np#" or "2Yu&". The functions return random numbers from 0-9, uppercase letters A-Z, lowercase letters a-z, and special characters. Understanding how to use Excel functions to generate random values can help when creating lists, simulations, or passwords.

Uploaded by

lechu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Generating text strings and passwords in Excel

To create a random text string in Excel, you just have to concatenate several CHAR /
RANDBEETWEEN functions.

For example, to generate a list of passwords consisting of 4 characters, you can use a formula
similar to this:

=RANDBETWEEN(0,9) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(97, 122)) &


CHAR(RANDBETWEEN(33,47))

To make the formula more compact, I supplied the ANSI codes directly in the formula. The
four functions return the following random values:

 RANDBETWEEN(0,9) - returns random numbers between 0 and 9.


 CHAR(RANDBETWEEN(65,90)) - returns random UPPERCASE letters between A and
Z.
 CHAR(RANDBETWEEN(97, 122)) - returns random lowercase letters between a and z.
 CHAR(RANDBETWEEN(33,47)) - returns random special characters.

The text strings generated with the above formula would be something like "4Np#" or
"2Yu&".
Module 3. Spreadsheets (15Hrs)

Electronic spreadsheet features -menu, cells, workbook, work sheets-Entering data, text,
functions -selecting cell –ranges -saving worksheet -Editing worksheet data -copying, cut&
paste -inserting, deleting rows, columns, cell ranges -find and replace data -spell check.

Formatting worksheet – changing column width, row height, aligning data - controlling text
within a cell - changing font size, style - applying border, pattern styles – charts - types, titles
& legends, saving, moving and copying between sheets.

Formulas, functions and Macros - Entering formulas – cell references - Date and time
formulas - working with range names - entering functions – macros.

Printing – print preview - headers and footers - inserting, removing page break - working
with data in a list – Adding and removing sub totals – sorting - hiding and displaying data.

Ref :
1. Office 2007 All -in-One Desk Reference For Dummies
2. https://help.libreoffice.org/Main_Page
References:
1.Office 2016 All - In-One For Dummies -Peter Weverka
2. Office 2013 Library Excel 2013 Bible, Access 2013 Bible,
PowerPoint 2013 Bible, Word 2013 Bible Lisa A. Bucki
3. Adobe PageMaker 7.0 Classroom in a Book
4. Teach Yourself Tally ERP 9 Mr. Niranjan Jha

You might also like