求助excel生成车牌号,随机生成蒙E1数字+1字母+3数字。万分感谢!因为要上车牌,想先挑挑。 问题补充:比如蒙E5A146
="E"&RANDBETWEEN(0,9)&CHAR(65+RANDBETWEEN(0,25))&TEXT(RANDBETWEEN(0,999),"000")
下拉或右拉