Tracker
HOME    TRACKER    Excel

# Random Letter Generator

## I know how to use RAND for numbers, but is it possible to use RAND for letters?

Related Forum Messages:
Random Name Generator
I'd like a spreadsheet that pulls out a random name.

I'll put in a lookup table, George, Fred, Ralf, Steve, Peter.

Sometimes Fred will come up, sometimes George will.

Random Names Generator
I like to know if this can be done using vb.

If I have a list of names of associates B2 to B32. Can I randomize the list in any order.

Then if I need to want that list to only randomize B2 to thru B30
Then if I need to want that list to only randomize B2 to thru B28

And so forth.

Sort of being able to pick from a pop up message box or userform that will ask you how many names to randomize in that list.

I wrote this to help me generate a random password for a workbook. I am happy with it so far, but I was wondering if there is a way, to shuffle the order of the variables? So, instead of MyPassword always being A, B, C, D, E etc

Sub RandPass()
Dim A As String, B As String, C As String
Dim D As String, E As String, F As String
Dim H As String, I As String, J As String
Dim K As String, L As String, M As String
Dim v

ReDim v(33 To 47) As Variant
A = Chr(Int((UBound(v) - LBound(v) + 1) * Rnd + LBound(v)))..............

Random Word Generator
Has anyone seen an Excel program that will generate words based on letters entered. For example, if I had 10 cells in a row, and each cell contained a letter (duplicates are okay), what words could be derived from arranging those letters in random sequences.

It would need the ability to accept any letter of the alphabet, A thru Z

E A L R C T S S U C
___ ___ ___ ___ ___ ___ ___ ___ ___ ___

How many words could it generate, and what are the words?
I assume it would have to reference a spelling dictionary.

It could be used as a spelling learning game, etc.

Random Cell Generator ...
I have a list of 200 comments in column B (B1:B200). In a seperate sheet I want to be able to add a function that calls a comment randomly.

So evertime I hit F9 the comment changes.

Random Winner Generator
I need a formula that can randomly pick a persons dependent on the amount of entries they have in a competition. For Example

PersonEntries
Andrew10
Jake15
Louisa4
Fuffy33

In the above case there is 62 entries into the draw. Andrew has 10 chances to win. Is there a formula that I can use that will decide a winner for me dependent on how many chances they have.

Random Generator With Several Outputs
I need a formula to create random letters down a column: A-F. Probability of A=3%, B=6%, C=8%, D=11%, E=14%, F=16%. I've got it worked out to where each letter is a header of a column ("A" is in A1, "B" is in B1, etc.). My question is: how do I consolidate that in one column, so that, "A" for example, reads ABFCBACFBFBECEABCEABCEAFBCEFBCAFEBCFAEBFC...? I'm using the random number generator for the 6 columns...thx

Random Generator, Change A Line Or Two
I have a random Generator but it only generates values that are different, is it possible to change a line of code to allow it to duplicate the same number? Here is the code I have and it works great but not for duplication:

Sub Unique_Numbers()
Dim x As Long, y As Long, z As Long, tempnum As Long
Dim flag As Boolean
Dim i As Integer
Dim foundCell As Range
Application.ScreenUpdating = False
x = Application.InputBox("Enter starting Random Number" _
, "Random Number Generation", 1, , , , , 1)
y = Application.InputBox("Enter ending Random Number" _
, "Random Number Generation", 1000, , , , , 1)
z = Application.InputBox("How many random numbers would" _
& "you like to generate (

Random Group Generator Tonight
I am to supply this tomorrow!! I have a column of 60 names that I need to break into 15 groups of 4. {this is actually for making a group of 4 names to get together each month for a dinner discussion} I need to generate a random mix so that each month everyone is with someone new until it begins to overlap. I am a relative elementary user of excel but understand that in some manner the "RAND"[?] function.

Random Number Generator Macro
What I'm trying to do is as follows:

Sheet 1
A1 through A6 has STR, DEX, CON, INT, WIS and CHA. B1 through B6 is waiting for results from sheet 2.

Sheet 2
A1 is data validation of d4, d6, d8, d10, d12, d20 and d100. A2 through A7 are currently Rand formulae triggered by A1 with B1 adding number of dice (minimum 1) and B2 a modifier value add to the rolled result. D2 through D7 are data validation modifiers of -10 to +10 (0 included). E2 through E7 is the result of A2+C2. The Rand works fine, but every time data is changed Rand recalculates. I'm hoping for a macro executed by a button to generate six random numbers based on the chosen die value of A1 ranging from 1-4 to 1-100. The die roll can never be below 1 and no higher than the chosen die. I then want to transfer the result from E? To sheet 1 B1 to B6 matching its appropriate atribute. I named them Char01_STR, etc on sheet 1 A1 to A6.

Random Number Generator Formula
I have 4 names, and a grid of 100 boxes. I need those 4 names randomly deposited in the 100 boxes, making sure each name is displayed an equal number of times (25 each) Is there an Excel formula to compute this?

To Make A Random Word Generator
I know you can make a random number generator pretty easily in excel...but is it possible to make a random word generator? I will give the words I want randomly generated.

Basic Random Number Generator
how to create a basic random number generator within an excel spreadsheet?

Basic Lower limit = 0
Basic Upper limit = 100

Random Number Generator From 1 To 7 Other Than Cell Value
I have a range of cells that have values from 1 to 7 in them. What I would like to do is to have the next column generate a random number from 1 to 7 that does not generate the number that the cell next to it has. for example if cell A1 has 6 in it, I would like cell b1 to generate a random number other than 6 in it. if cell A2 has 3 in it then cell B2 would generate a number other that 3 (1,2,4,5,6, and 7).

Random Message Box Generator
i want is a way, on clicking a button on my userform, where i can bring up a quote randomly picked from a list of quotes and sayings which I will input.

Random Number Generator Based On Weibull Distribution
how to go about generating random numbers based on Weibull distribution in VBA? I had a rough idea for Normal (from link below) which i later extended to Lognormal but am having difficulty with Weibull and Gamma will appreciate any help.

http://www.devx.com/vb2themax/Tip/19233

Positive Random Number Generator From Normal Distribution

I would like to get random number generator for normal distribution and I’m using:

=NORMINV(RAND(),\$B\$1,\$B\$2)

Where B1 is mean (average) and B2 is SD.

This command works, but in the random generating numbers, I’m getting positive and negative numbers (ex. -23,34).

how to change command so I can generate positive only numbers?

How Do I Use VBA Timer Subroutines To Start And Stop Random Number Generator
As you can see below, I've written code that writes random numbers into three columns of a spreadsheet (10 numbers in each column).

What I want to do is create code that will run the random number generator for a period of 1 minute and then stop. I know that I will need to write a timer subroutine to do this but I'm how unsure how to do this.

Change And Show Letter With F9 Or Random Or Any Formula
I just want to show a letter and change it to any letter and show it again in seconds. Can it be done with formula, maybe with RAND formula or any other formula.

for example when i press F9 the letter A change B, and then i press F9, it changed to C, and then when i press F9 and it changed to A again, and i press F9 and it changed to B, and so on...

(Is it possible too..with a little variation if i press F9 continually, it changed every 5 second?)

Random 3 Letter Prefix Form (left, Right, Mid)
i need to create a random 3 letter prefix form eg. British Head Office, how would you pick letters out and compare the 3 letter prefix back to a column with existing prefix. and if u can help me even more how can i automate this method beacuase i for eg. get like 50 company names at a time and dont have time to do and check them 1 by 1 lol.

Return Column Letter Based On The Letter In A Cell.
For the below formula is it possible to replace the B's (column location) with a cell Say Z146 which contains the letter B (or a number if thats easier and someone can tell me the numbers for each column).

When the formula is dragged into the next cell (down) it takes its column reference from Z147 and then my life becomes so much easier.

=IF(INDEX('Overs-Unders'!B:B,MATCH(\$C145,'Overs-Unders'!\$A:\$A,0))"",INDEX('Overs-Unders'!B:B,MATCH(\$C145,'Overs-Unders'!\$A:\$A,0)),"")

Convert Lower Letter To Capital Letter Automatically
When I type a single lower case letter into a cell, what formula or conditional formatting should I use to always convert it to a capital letter automatically?

Generate Random Numbers In Random Cells
I am working on a Random Cycle Count Generator that provides random SKU#s based on 3 separate columns of SKU listings. The user clicks a button to generate the SKU#s to cycle count for that day. What I would like to see is a date stamp in the columns next(B,D,F) to the referenced SKU listing(A,C,E) based on which SKU#s are generated. This will let me see the last date that the SKU was generated. I would also like it to automatically save after generating.

Time Generator
Im trying to write a spreadsheet to generate track times (anywhere from 9 seconds to 2 hours) for a RP. Im not really sure where to start, but if I can get a push on the start I can finish it out.

I got this code from this board and it works OK for generating 1 password. What I want to do is to generate X amount of passwords on to sheet2, so if I use cell B1 as the amount of passwords required it will generate that amount on sheet 2. I tried doing a loop, but had no luck with it, (Not ruling out user error at this end)

Dim LC As Byte 'Loop Counter
Dim strRndmChr As String
Dim LAC As Byte 'Lowest Ascii Character
Dim HAC As Byte 'Highest Ascii Character
Dim UseSymbolics As Boolean
Dim HasSymbolics As Boolean
Dim RandomNumber As Byte

'Set parameters.

Top 5 Generator
my spreadsheet logs call references and total times, as well as the date.

All the data is stored in the worksheet 'Data' while I want this report to be generated under the worksheet 'Admin' - I do not want it to be live either, I would want it so you press a button to generate the report so the data does not change (hopefully making this easier in the process).

There are 2 things I want to do with the report, first is to log all the calls by date to generate an average per day. Secondly, I want to generate a list of the 5 longest calls so these can be reviewed.

Lottery Number Generator
Does anyone know of an Excel macro or function that can generate say 1000 strings of 6 numbers from 1 to 49, without repeating the same combinations?

Kind of like the random picks that lottery machines generate.

Data Validation Format Letter Number Letter Number Etc.
I want to apply Data Validation to a cell, so that only the following combination of letters and numbers can be entered.

Letter Letter Number Number Number Number Number Number Letter.
e.g AB123456C.

First Letter Of The Last Name
I would like to ask if this is possible, I attached the sample and the problem is there for better understanding of what i want to achieve.

Producing A Letter
if it possible to produce a letter in excel like you would in word by mail merging.

i dont want to open word as i dont have it on my work pc.

im wondering if it possible to do something like this

dear ( sheet 1 cell 1 )
thank you for your order of ( sheet 1 cell 2 ) we wish to deliver to you on ( sheet 1 cell 3 )

The Magic Letter
In the Range "C5:C20" if the user types in S in one of the Cells, I would like the Cell Selection to move three Rows to the right. In other words ActiveCell.Offset(0,3), I need to put this in the WorkSheet Change Code.

Replace The Letter
=IF(R16="A",D11,IF(R16="B",G11,IF(R16="C",J11,IF(R16="D",M11,IF(R16="E",P11,0)))))

i want to replace the letter A,B,C,D,E, with numbers from 1-5.
When I take of the """" and replace the letter with the numbers the formula does not work.

Get Each Letter From String
Can I use a string in VBA just like C. I'm trying to get character one by one for a string. Can I do somehting like that here?

In C I use:
char string[20];
For ( int i = 0; string[i] != '"; i++)
cout << string[i];

How To Check For A Particular Letter In A Column
Basically, I need to be able to determine whether a particular letter is stored with another letter in the 'CG column' of the attached spreadheet.

The criteria is this:

1. Letter J can be present as long as there is no other letter in that column.
2. Letter B and D cannot be together in the column, but B can be with any other letter and likewise for D.

Basically, I could have a load of Js in the CG column and that would be fine. If another letter was with those Js, I need a warning box. I could have a B,H,S,T etc.....and that would be fine, but as soon as a D is entered, I need a warning. Similarly, if I had D,H,I,U,T etc......that would be fine too, but as soon as a B is entered, I need a warning again.

Alphabetically Start From Letter
If i type some word (first 4 to 5 word) or more.

if I m start letter from AK …….

possible to display in side popup window which letter start from ak in our previous record i.e. akashwani or akshare like that. I dont want through vba or access because i m not use before. I want same excel sheet.

We have attach sample sheet.

Determining Any Uppercase Letter
My question is about determining whether or not a particular letter is uppercase.

I've written code that reads from a text file one character at a time. And I know that the following determines if each character is equal to the letter "a".

Count Letter W In The Last 5 Entries
I want to count how many "W" are in the last 5 data entered. How can I do this? See attached sheet as an example - need to count the "w" in column C.

Convert Letter To Number
Is there simple function that anyone knows of (or has written) that will convert a letter to its alpha-numeric equivalent?

For instance, A = 1, B = 2, AA = 27, etc (a = 1, b = 2, aa = 27)

Capitalize First Letter Of Each Sentence
Is it possible in Excel to capitalize just the first letter of sentence?

Something from this:

"Capital first letter only. After Period Should be capitalized only The First Letter"

to this:

"Capital first letter only. After period should be capitalized only the first letter"

Letter Association With Numbers
On column "F" I have all the names listed, they are all lowercase, and with different length. How do I write a formula to turn those names into numbers?

For an example. In column F1 I have "James". And using letters = numbers

9 = A L T
8 = B N W
7 = E P X
6 = G R Y
5 = I J
4 = H S
3 = F Q Z
2 = D O U
1 = C M V

I would like the column G1 to display "59174"?

Would need the convention from letters to numbers on Column G adjacent with the name.

Formula For A Letter Typed
I am trying to make a puzzle and use excel to verify I have done it correctly.
What I want to do is when I type a letter in a specific cell have it put a number value in another cell automatically. For instance, if I type the letter "a" in cell A1 I would like the number 60 to populate automatically in cell B1. I want to give each letter in the alphabet a numeric value so I can type a message in the A column and then auto sum the results of the numbers in the B column.

Name Cells With Same Letter But Different Number?
Is there any way to name cells with same letter but different number?

e.g i need to name the first row A1 to A100.

Number Of Letter In A Cell
I have a list of names and I need to know how many names are greater than 6 characters in length. What is the formula I need to enter?

Capitalizing First Letter In Each Word
I have 30,000 lines and in each line I have words that have all capital letters.
What I want to do, is make only the first letter in each word capital, and the rest lowercase.

Populating Cell With A Letter
I have a colum with 350 cells in use, each of these cells contain a 3 digit number. Without having to go into each cell and type is there a way i can put the Letter
"R" infront of each of the 3 digit numbers?

Highest Letter In A Row
I'm trying to list the latest revision of a drawing in an issue sheet spreadsheet. What I need is to be able to enter a formula that will find the highest alphanumerical value in the columns beyond. Alphabetic characters take precedence over numerical - i.e., drawing issue numbers usually follow a 00, 01, 02, 03, then switch to A, B, C, D,... order.

To try and illustrate what I mean a little better, I have the following table, with dates in DD/MM format. Sorry it's not laid out too well, my HTML isn't great:

Drawing title latest revision 01/01 02/01 03/01 04/01 05/01 06/01
example010001AB
example02000102
example0300

I want the cells in the "latest revision" column to report the highest value. So, I want it to say this:

Drawing title latest revision 01/01 02/01 03/01 04/01 05/01 06/01
example01B0001AB
example0202000102
example030000

I won't have control over the numbers and letters reached (i.e., the drawing revision could get up to Z or something - or the number revision reach 15 before switching to alphabetic revisions) so I'd rather avoid having to set up a crazy IF function with "00", "01", "02", "03", "04", etc etc. But -

Return The Letter Value Of A Column
When I used "activecell.column" it returns the numerical value of a column (For Example: Column B would be 2).

I use the following in my
Dim StrRef As String
StrRef = "AN"

I want to be able to refer to column "AN" without having to hardcode "AN" into my code becuase it may change.

Below is part of the Code where I refer to "AN" in context of a loop---

For Each icell In ActiveSheet.Range(StrRef & "7" & ":" & StrRef & LastRow)

I tried Activecell.Address but that return the entire cell reference.

Remove Trailing Letter
I have a set of data with trailing Y in certain cells.

Instead of the replace function in Excel, is there another way of removing the "Y" in that cell and storing it another cell while keeping the numbers before the Y.

i've created another column to determine which cells has Y as the right most character by using =IF(RIGHT(F2,1)="Y","Y","")

So for example, I want to remove the Y from say Cell A2 and store it in say cell A3 while still keeping the value 8624.46 in A2

Cell A2 = 8624.46Y

Caps To First Letter Cap..
I like the proper formula and find it handy, however do you know if there is a formula that would only keep the first letter in the cell at caps and reduce the rest to lower case, ie

A1 = MY DOG IS WHITE
proper(A1) = My Dog Is White
what I want is only first letter caps = My dog is white. I'va had a decent look around but can't find anything that would do this?

Replace A Letter With A Word
Column A has cells showing either Y or N I want Column B to take a Y and convert it to a Yes and N to No. I tried an IF statement but it wont seem to work.