ããå¨å©ç¨Excelè¿è¡åå
¬æ¶ï¼å¯¹å符串è¿è¡å并æ¯å¸¸è§çä¸ç§æä½ãä¸é¢å°ç¼å°±ä¸å¤§å®¶ä¸èµ·å享ä¸ä¸å¨Excelä¸å®ç°å符串å并çæ¹æ³ã
ããæ¹æ³/æ¥éª¤
ããå©ç¨â&âè¿æ¥å符æ¥å®ç°å符串çå并ï¼
ããåªéè¦å°å¤ä¸ªå符æå符串éè¿ä½¿ç¨â&â符è¿æ¥èµ·æ¥å³å¯ãå¦å¾ï¼å¨A1åå
æ ¼ä¸è¾å
¥å
¬å¼ã="ç¾åº¦"&" ID:"&"feifeidown"ãå³å¯å®ç°å符串çå并ã
ãã该æ¹æ³åæ ·éå对æ°åè¿è¡å并è¿è¡ï¼ä¾å¦è¾å
¥å
¬å¼â=1&2&3âå³å¯å¾ç»æâ123âã
ããæ们è¿å¯ä»¥å©ç¨CONCATENATEå½æ°å®ç°å符串çå并æä½ï¼
ããå¨A1åå
æ ¼è¾å
¥å
¬å¼â=CONCATENATE("ç¾åº¦"," IDï¼","down")âå³å¯å并å符串ã
ããæ··åâ&âåâCONCATENAGEâå®ç°ææ¬å符串çå并ï¼
ããè¾å
¥å
¬å¼â=CONCATENATE("ç¾åº¦"," IDï¼",&"down")âå³å¯å¾ç»æã
ããæ们å¯ä»¥å©ç¨å¯è§åçå导æ¥ä½¿ç¨å
¬å¼ï¼
ããåæ¢è³âå
¬å¼âåè½åºï¼ç¹å»âææ¬âä¸æå表ï¼ä»ä¸ç¹å»âCONCATENATEâå½æ°å³å¯å¨å¼¹åºççªå£ä¸è¾å
¥å个ææ¬å符串å®æå并æä½ã
温馨提示:答案为网友推荐,仅供参考