ç¹èåçç¼è¾ï¼æ¿æ¢ï¼æ¥æ¾å¤è¾å
¥aæ¿æ¢å¤è¾å
¥Aå
¨é¨æ¿æ¢ï¼...ä¹å¯ä»¥ç¨å
¬å¼æ³ï¼å¨Sheet2çA1è¾å
¥=IF(Sheet1!A1="","",upper(Sheet1!A1))å³é®å¤å¶A1ï¼éä¸A1å°H100ï¼å车ç²è´´ï¼æ¥çå³é®ï¼å¤å¶ï¼åå³é®ï¼éæ©æ§ç²è´´ï¼æ°å¼ï¼ç¡®å®ãç¶ååå°Sheet1ï¼éä¸Aå°Håï¼ç¹èåçæ ¼å¼å·ï¼å°Sheet2ï¼ç¹Aå°Håï¼å®æã
温馨提示:答案为网友推荐,仅供参考