é¦å
æ¥åä¸é¡¹åå¤å·¥ä½ï¼
1. åå¤ä¸äºå¸¸ç¨å§æ°ï¼100个就å¤äºï¼ç½ä¸æä¸ä¸å§ï¼bai
2. åå常ç¨æ±åãææ¾äº300个ï¼ç»å¸¸åºç°å¨å§åå½ä¸çæ±åä¹å°±300å¤ä¸ªå§ï¼
ä»ç½ä¸ææ¥çå¾å¾ç¨ç©ºæ ¼æâï¼ââãâçéå¼ï¼éè¦æè¿äºå符æ¿æ空ï¼ä¸æ¯æ¿æ¢æç©ºæ ¼ï¼èæ¯ä»ä¹ä¹æ²¡æã
æå§æ°æ±åæ¾å¨E1åå
æ ¼ï¼ååæ±åæ¾å¨E2åå
æ ¼ã
åæ¥å¤ä¹ å 个ç¸å
³çå½æ°ä»¥åå½æ°çåµå¥ä½¿ç¨ï¼
å
å¤ä¹ ä¸ä¸éæºå½æ°å§ï¼
å
¬å¼1 =RANDBETWEEN(1,100) éæºçæä¸ä¸ª1å°100ä¹é´çæ´æ°ã
è¿ä¼ç¨å°ä¸ä¸ªå½æ°ï¼MID()
å
¬å¼2 =MID(E1,10,1) ä»E1åå
æ ¼ç第10个å符å¼å§ååº3个å符ã
å¦ææå
¬å¼2ä¸ç10æ¢æ1å°100ä¹é´ç
éæºæ°ï¼ä¹å°±æ¯æå
¬å¼2ä¸ç10æ¿æ¢æå
¬å¼1ï¼è¿æ ·å°±ä¼å¾å°ä¸ä¸ªéæºçå§æ°ã
å
¬å¼3 =MID(E1,RANDBETWEEN(1,100),1) å¾å°ä¸ä¸ªéæºçå§æ°ã
ç°å¨æ们å¯ä»¥çæéæºå§åäºã
è¿æ¯å
¬å¼åè²ï¼
=MID(MID(E$1,RANDBETWEEN(1,100),1)&MID(E$2,RANDBETWEEN(1,300),1)&MID(E$2,RANDBETWEEN(1,300),1),1,RANDBETWEEN(2,3))
çä¸å»ä¹±ç³ç³çï¼å
¶å®å°±æ¯è¿æ ·çç»æï¼
=å§&å&åï¼å
çæä¸ä¸ªåçå§åã
å
¬å¼ä¸çâ&âç¨æ¥æ两边ç
å符串è¿æ¥å¨ä¸èµ·ã
å
¬å¼ä¸âå§â代表éæºçæçä¸ä¸ªå§æ°ã
å
¬å¼ä¸âåâ代表éæºçæçä¸ä¸ªååã
å¨æ¤åºç¡ä¸ï¼å¤é¢åå¥ä¸ä¸ªå½æ°ï¼éæºå两个åæä¸ä¸ªåå½¢ææç»çå§åï¼
=MID(å§&å&å,1,RANDBETWEEN(2,3))
以ä¸ä¾åèã