Generating Random data in Excel
Sometimes we are required to use a list of names constructed from some chars followed by random numbers In order to use the parameter type FILE in LR parameter list with names constructed from chars followed by random numbers you might be require to develop a function to create names dynamically. Use the excel functions below to generate a random chars strings followed by random number generated between a given range, one for uppercase chars and the other for lowercase chars, as shown below. The prefix can be changed according to your needs, with simple adjustments. It’s a simple but effective way to create a list of names to suite our needs. Functions : Starting Letter Capital F followed by 6 small Letters =TEXT(RANDBETWEEN(97,122),)&CHAR(RANDBETWEEN(70,70))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122)) Output:-