Luke M Excel Ninja Staff member Jun 13, 2012 #2 sure thing. Just concatenate the two things. Example: ="Random number is: "&RANDBETWEEN(1,100)
N NARAYANK991 Excel Ninja Jun 13, 2012 #3 Hi , You can take a look at this : http://www.tushar-mehta.com/excel/tips/rand_alphanum.html Narayan
Hui Excel Ninja Staff member Jun 13, 2012 #4 Sunnyp Have a read of: http://chandoo.org/wp/2011/05/04/dummy-data-random-functions/