=CHAR(65+INT(RAND()*26))&INT(RAND()*10)&INT(RAND()*10)&INT(RAND()*10)&INT(RAND()*10)&INT(RAND()*10)一共就六位还要保证不重复,甘脆1,2,3加上去好了。上面这个不能保证不重复。用于excel