第3个回答 2014-12-05
=UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))&UNICHAR(INDEX({65,67,71,84},RANDBETWEEN(1,4)))
数组公式本回答被提问者采纳