We have these entries in row 1 of our sample spreadsheet:įormula for email address (column C): =LOWER( CHAR (RANDBETWEEN( 97, 122 ))& CHAR (RANDBETWEEN( 97, 122 ))&SUBSTITUTE(INDIRECT( CHAR (RANDBETWEEN( 65, 66 ))&ROW()), " ", "" )&RANDBETWEEN( 0, 99 )& )
In addition, the GD email addresses don't appear to have a consistent letter case and length pattern while the FIG email addresses have: = 2 random lowercase letters + either first name or last name + random number from 0 to 99 + YopMail email addresses and GID-style passwords in Excel would save me time instead of having to generate hundreds of fake identities one at a time in FIG just to get names, emails and passwords (copying and pasting could lead to human errors like missing passwords).
GD: LLLxxLLLxLL = three uppercase letters, 2 random digits, another 3 uppercase letters, a single digit, and 2 uppercase letters. And the GD-generated passwords are in ALL CAPS and are not as easy to remember as the passwords generated by FIG:įIG: lxxxxxxlxl = lowercase letter followed by 6 random digits followed by a lower case letter, a single random digit, and ending in the same letter as the beginning. In contrast, GD-generated emails are really fake (apparently using a Latin randomizer) and don't relate to the names. I find FIG-generated email and passwords easier on the eyes and more useful (YopMail addresses all have their own temporary inboxes in case you need to read an email confirmation).