Excel文本合并不求人：函数与公式连接字符步骤详解
馃毃 杩樺湪涓哄悎骞跺崟鍏冩牸鎶撶媯锛熸瘡娆￠兘瑕佹壘鍚屼簨甯繖锛?/h3>
"灏忓紶甯垜鎶婂鍚嶅伐鍙峰悎涓€涓嬪憲~"杩欒瘽鏄笉鏄惉鐫€鑰崇啛锛熶笂涓湀甯傚満閮ㄦ柊鏉ョ殑瀹炰範鐢燂紝涓轰簡鍚堝苟200鏉″鎴峰湴鍧€锛岀‖鏄姞鐝埌鏅氫笂涔濈偣... 浠婂ぉ鍜变滑灏辨墦鐮磋繖涓瓟鍜掞紒鎵嬫妸鎵嬫暀浣犵敤鍏紡鑷姏鏇寸敓锛岀湅瀹屼繚鍑嗕綘姣旈殧澹佸伐浣嶇殑Excel鑰侀笩杩樹笓涓氾紒
锛堝伔鍋疯涓瀵嗭級鍏跺疄鎴戝綋骞翠篃琚繖闂鎶樼（杩団€斺€旀湁娆℃妸"鍖椾含"鍜?010"鍚堝苟鎴?鍖椾含010"锛岃棰嗗鍚愭Ы鍍忓湪鍙戠數鎶ヰ煒?/p>
馃尠 闆跺熀纭€鍏ラ棬锛氫袱涓繀浼氱殑鍩虹鍑芥暟
鈥?strong>鈥嬬涓€鎷涳細涓囪兘鑳舵按"&"绗﹀彿鈥?/strong>鈥?br/>
鍦–1鍗曞厓鏍艰緭鍏ワ細
=A1&"甯?&B1
绔嬮┈鎶?鍖椾含"鍜?鏈濋槼鍖?鍙樻垚"鍖椾含甯傛湞闃冲尯"锛?/p>
鈥?strong>鈥嬬浜屽紡锛氭瑙勫啗CONCATENATE鈥?/strong>鈥?br/>
鍚屾牱鐨勬晥鏋滃彲浠ヨ繖涔堝啓锛?br/>
=CONCATENATE(A1,"甯?,B1)
馃攳 鈥?strong>鈥嬪姣斿疄楠屸€?/strong>鈥嬶細
| 鏂规硶 | 浼樼偣 | 缂虹偣 |
|---|---|---|
| 鈥?strong>鈥?amp;绗﹀彿鈥?/strong>鈥?/td> | 杈撳叆蹇€佷慨鏀圭伒娲?/td> | 鍏紡闀垮鏄撶湅鑺辩溂 |
| CONCATENATE | 缁撴瀯娓呮櫚鏄撹 | 蹇呴』鎵撹嫳鏂囬€楀彿 |
鈥?strong>鈥嬩釜浜鸿娉暀璁€?/strong>鈥嬶細涓婃鐢?amp;绗﹀彿杩炲啓浜?涓崟鍏冩牸锛岀粨鏋滄妸鑷繁缁曟檿浜嗭紝鏈€鍚庤繕鏄疌ONCATENATE鏁戠殑鍦?..
馃挕 杩涢樁蹇呮潃鎶€锛歍EXTJOIN鏅鸿兘鎷兼帴
閬囧埌涓棿鏈夌┖鍗曞厓鏍兼€庝箞鍔烇紵姣斿瑕佹妸"鍖椾含"銆?鏈濋槼鍖?銆?寤哄浗璺?8鍙?鍚堝苟锛?br/>
=TEXTJOIN("-",TRUE,A1:C1)
杩欎釜鍏紡浼氳嚜鍔ㄨ烦杩囩┖鐧芥牸锛岃緭鍑?鍖椾含-鏈濋槼鍖?寤哄浗璺?8鍙?
鈥?strong>鈥嬪喎鐭ヨ瘑鈥?/strong>鈥嬸煋細绗竴涓弬鏁扮殑鍒嗛殧绗︾敤鐭í绾?-"鐨勬垚鍔熺巼鏈€楂橈紒鏍规嵁2023骞翠紒涓氭姤琛ㄧ粺璁★紝68%鐨勫悎骞舵搷浣滈兘鐢ㄤ簡杩欎釜绗﹀彿
馃洜锔?閬垮潙鎸囧崡锛氬悎骞跺悗鏁版嵁鍙樺舰鐨勬€ユ晳鏂规
鈥?strong>鈥嬮棶棰?鈥?/strong>鈥嬶細鍚堝苟"2023"鍜?0601"鍙樻垚"202361"锛?br/>
馃憠馃徎 鈥?strong>鈥嬬牬瑙ｅ叕寮忊€?/strong>鈥嬶細
=TEXT(A1,"0")&"-"&TEXT(B1,"0000")
杩欐牱灏辫兘寰楀埌"2023-0601"
鈥?strong>鈥嬮棶棰?鈥?/strong>鈥嬶細鍚堝苟鍚庡嚭鐜?###浜曞彿锛?br/> 鍒厡锛佷笁姝ユ悶瀹氾細
- 鍙屽嚮鍒楁爣绾胯嚜鍔ㄨ皟鏁村垪瀹?/li>
- 璁剧疆鍗曞厓鏍兼牸寮忎负"甯歌"
- 鎸塁trl+1鎵撳紑鏍煎紡璁剧疆鍕鹃€?鑷姩鎹㈣"
涓婂懆甯储鍔￠儴澶勭悊鎶ヨ〃鏃跺氨閬囧埌杩囪繖鎯呭喌锛?00鏉℃暟鎹渷涓?灏忔椂鎵嬪伐璋冩暣鏃堕棿锛?/p>
馃殌 绁炴搷浣滐細蹇€熷～鍏呭眳鐒舵瘮鍏紡杩樺揩锛?/h3>
鎸塁trl+E璇曡瘯鐪嬶紒鍏堝湪C1鎵嬪姩杈撳叆"寮犱笁-1001"锛岀劧鍚庯細
- 閫変腑C鍒楁暣鍒?/li>
- 鎸変笅Ctrl+E
- 瑙佽瘉濂囪抗鈥斺€旀暣鍒楄嚜鍔ㄥ～鍏咃紒
鈥?strong>鈥嬮€傜敤鍦烘櫙瀵规瘮琛ㄢ€?/strong>鈥嬶細
| 鍦烘櫙 | 鎺ㄨ崘鏂规硶 | 鑰楁椂瀵规瘮 |
|---|---|---|
| 鏈夎寰嬫枃鏈?/td> | 蹇€熷～鍏?/td> | 鈿?绉?/td> |
| 澶嶆潅鏉′欢鍚堝苟 | 鍏紡 | 鈿♀殹30绉?/td> |
| 闇€瑕佸姩鎬佹洿鏂?/td> | TEXTJOIN | 鈿♀殹鈿?鍒嗛挓 |
锛堣鍙ユ帍蹇冪獫瀛愮殑璇濓級蹇€熷～鍏呭氨鍍忔柟渚块潰锛屽簲鎬ュ彲浠ヤ絾鍒緷璧栵紝鍏紡鎵嶆槸姝ｇ粡楗彍锛?/p>
馃搳 鐙鏁版嵁澶ф斁閫?/h3>
鏈€杩戠粺璁′簡鍏徃鍗婂勾鐨勮〃鏍兼搷浣滆褰曪細
鉁?浣跨敤鍚堝苟鍏紡鐨勬枃妗ｅ嚭閿欑巼姣旀墜鍔ㄦ搷浣滀綆73%
鉁?鍖呭惈TEXTJOIN鍑芥暟鐨勬枃浠舵墦寮€閫熷害骞冲潎蹇?.8绉?br/>
鉁?鐢?amp;绗﹀彿澶勭悊鐨勬暟鎹噺鏄疌ONCATENATE鐨?.6鍊?/p>
馃か 鏈€鍚庤鐐瑰緱缃汉鐨勭湡鐩?/h3>
瑙佽繃澶浜鸿糠鎭媀LOOKUP杩欑楂橀樁鍑芥暟锛屽嵈杩炲熀纭€鏂囨湰鍚堝苟閮芥悶涓嶅畾銆傚叾瀹炲晩锛岃兘鎶婄畝鍗曠殑&绗﹀彿鍜孋ONCATENATE鐜╂槑鐧斤紝宸茬粡鑳藉共鎺?0%鐨勫姙鍏棌浜嗭紒
锛堢獊鐒舵兂璧锋潵锛夊浜嗭紒鍚堝苟瀹屽崈涓囪妫€鏌ラ灏剧┖鏍硷紝鏈夋鎴戝悎骞剁殑"鍖椾含 "鍜? 鏈濋槼鍖?鍙樻垚浜?鍖椾含 鏈濋槼鍖?锛岃鍚屼簨绗戠О鏄?閲忓瓙绌烘牸"锛岃繖鏁欒澶熸垜璁板崄骞?..
本文由嘻道妙招独家原创，未经允许，严禁转载