LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 788
Default How to? Create random letters and numbers in a cell

Hi All,

I used a spredsheet to create new users onto our network.
We input their name, job title, server and their password they will use to
login to windows.

Is it possible to make some random charaters appear by clicking on the
password cell? EG.

Name Job Function Password Server
John Smith CSR <CLICK Bristol

these passwords have to be in this Format: 2 Uppercase, 5 lower case, 1number.
i.e

UUlllll1

is this possible?

Regards,
Chris



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I create a list of random numbers with no duplicates? Kwasniewski Excel Discussion (Misc queries) 2 May 15th 06 02:44 AM
create self-generating numbers with letters and numbers cxlough41 Excel Discussion (Misc queries) 11 January 4th 06 01:16 AM
Can I create a random order within a series of numbers in Excel? Dimtrax Excel Worksheet Functions 2 November 9th 05 03:40 PM
create random NON-REPEATING numbers (e.g., 20 #'s between 1-100) Leon Excel Discussion (Misc queries) 1 June 3rd 05 12:20 AM
If I create a random list in Excel, does it repeat numbers? Kelly Excel Worksheet Functions 2 March 30th 05 04:05 AM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"