Excel – generate random sample data file

by robin · Published January 9, 2013 · Updated April 7, 2013

Some formulas that will help you build sample data files

Random number generation

=RANDBETWEEN(1,1500)

Generates random number between 1 and 1500

=CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))

Generates random text of 3 characters