how to make a random character generator in excel?

Question

I need to have sone characters randomly generated for a mod I'm making in a game. just to build up a little history behind them and be able to use them.

I heard you can do that with excel, but I'm lost as to how.
I heard someone made something when they typed a string of numbers, and a random character was made.
anyone know if it's possible? and if so, how could I make something like that?

Answer 1

...Edit 27-07-09



Thanks for the clarification of your requirement.



Use one column for each of your character's parameters, then use the following formula above each column:



=INDEX(Xa:Xb , ROUND(1 + RAND() * c , 0 ))



Substitute for X, a, b and c

Where:

X = the column letter

a = the row number at which your parameters start

b = the row number at which your parameters end

c = the total number of parameters in the column minus 1 or just (b - a)



For example, the first column might be the character's christian name.



Row number: Column A

5--------------------------Tom

6--------------------------Robert

7--------------------------Ann

8--------------------------Bill

9--------------------------Clare





For this parameter, the formula would be entered as:



=INDEX(A5:A9 , ROUND(1 + RAND() * 4 , 0))



You can populate as many parameter tables as you like, eg:

1stName, Surname, HomeTown, Occupation, Age, Marital status, ShoeSize... etc... etc...



As with my previous answer, re-calculating the spreadsheet (F9) will select a new set of random numbers for the parameter index look-up.



Cheers.

Answer 2

Excel Random Character Generator

Answer 3

press alt and f4