第4个回答 2012-06-01
=MID("ABCDEFGHIJKLMNOPQRSTUVWXYZ",RAND()*26+1,1) & TEXT(RAND()*100000000000,"00000000000")
第5个回答 2017-11-10
=CONCATENATE(CHAR(RANDBETWEEN(65,90)),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9),RANDBETWEEN(0,9))