Skip to main content

Excel and Google sheets

lower case, no spaces, join two words. =LOWER(SUBSTITUTE(CONCATENATE(A2&B2)," ",""))

Random number =RAND()*9999

1st letter of string LEFT(TRIM(B1),1)

concat two cols and add random 4 numbers after =LOWER(SUBSTITUTE(CONCATENATE(LEFT(TRIM(B2),1),C2,INT(RAND()*9999))," ",""))

Contcatenate with space =A1&" "&B1

#software/excel