Excel - generate random sample data file

Some formulas that will help you build sample data files

1.      Random number generation

=RANDBETWEEN(1,1500)

Generates random number between 1 and 1500

2.      Random text generation

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

Generates random text of 3 characters