涓€銆佸父瑙勫満鏅細鍗曞垪鏁版嵁蹇€熸嫾鎺ワ紙甯﹀垎闅旂锛?/h3>

鈥?strong>鈥嬮€傜敤鍦烘櫙鈥?/strong>鈥嬶細浜轰簨妗ｆ灏嗐€愬鍚?鐢佃瘽銆戝悎骞跺埌鍚屼竴鍒?br/> 鈥?strong>鈥嬫楠ゅ浘瑙ｂ€?/strong>鈥嬶細

1. 鍦ㄧ洰鏍囧垪杈撳叆=A2&"-"&B2锛堢敤鈥?鈥濊繛鎺ュ鍚嶅拰鐢佃瘽鍒楋級
   2 鈿♀€?strong>鈥嬭繘闃剁増鈥?/strong>鈥嬶細鐢?code>TEXTJOIN("-",1,A2:B2)鎵归噺鍚堝苟澶氬垪锛堟敮鎸佽烦杩囩┖鍊硷級
   鈻讹笍鐐瑰嚮鍗曞厓鏍煎彸涓嬭鍗佸瓧鍏夋爣鍚戜笅鎷栧姩濉厖

---

浜屻€佸鏉傚満鏅細澶氳鏁版嵁鏅鸿兘鍚堝苟锛堝甫鎹㈣绗︼級

鈥?strong>鈥嬮€傜敤鍦烘櫙鈥?/strong>鈥嬶細閿€鍞粺璁￠渶灏嗐€愬湴鍖?浜у搧+閿€閲忋€戝悎骞舵垚涓€鏉″畬鏁存弿杩?br/> 鈥?strong>鈥嬪叧閿搷浣溾€?/strong>鈥嬶細

1. 鍏紡鐢?code>CHAR(10)寮哄埗鎹㈣锛?code>=A2&CHAR(10)&B2&CHAR(10)&C2
   2 閫変腑鍒椻啋鎸?code>Ctrl+1寮€鍚缃啋鍕鹃€夈€愯嚜鍔ㄦ崲琛屻€?br/> 馃敟 鈥?strong>鈥嬫晥鏋溾€?/strong>鈥嬶細鍚堝苟鍐呭鑷姩鍒嗚灞曠ず锛圥C/鎵嬫満鏌ョ湅閮芥竻鏅帮級

涓夈€侀珮闃跺満鏅細鍗冧汉鏁版嵁涓€閿悎骞讹紙鏃犲叕寮忕増锛?/h3>

鈥?strong>鈥嬮€傜敤鍦烘櫙鈥?/strong>鈥嬶細鍚堝苟1000琛屽晢鍝併€愬瀷鍙?棰滆壊+搴撳瓨銆戝埌绔栧垪
鈥?strong>鈥嬪揩鎹烽敭鎿嶄綔娴佲€?/strong>鈥嬶細

1. 閫変腑闇€鍚堝苟鐨?鍒楁暟鎹?鈫?鎸?code>Ctrl+C澶嶅埗
   2 鍙抽敭鐐瑰嚮鐩爣鍒?鈫?榛忚创涓恒€愬€笺€戔啋 鎸?code>Ctrl+H鍚敤鏇挎崲鍔熻兘
   3 杈撳叆鏌ユ壘鍐呭^p 鈫?鏇挎崲涓虹┖鐧?鈫?鐐瑰嚮銆愬叏閮ㄦ浛鎹€?br/> 锛堝師鐞嗭細灏嗗鍒楃殑鎹㈣绗︽竻闄や负杩炵画鍐呭锛?/li>

---

鈿狅笍閬垮潙鎸囧崡锛氬悎骞跺墠蹇呯湅

1. 鈥?strong>鈥嬫牸寮忎涪澶辨尳鏁戔€?/strong>鈥嬶細鍚堝苟鏃跺厛淇濈暀鍘熸暟鎹垪锛岀敤Ctrl+Z鍙洖閫€鎿嶄綔
2. 鈥?strong>鈥嬫壒閲忓畾浣嶇┖鍊尖€?/strong>鈥嬶細鐢?code>Ctrl+G瀹氫綅鍚庡崟鐙鐞嗭紝闃叉鍚堝苟閿欎綅
3. 鈥?strong>鈥嬭法琛ㄦ牸鍚堝苟鈥?/strong>鈥嬶細鐢?code>Power Query涓殑銆愯拷鍔犳煡璇€戝姛鑳芥洿绋冲畾

鈥?strong>鈥嬪欢浼告妧宸р€?/strong>鈥嬶細鍚堝苟鍚庣殑鏁版嵁鑻ラ渶鐢熸垚鏉″舰鐮?浜岀淮鐮?br/> 鍙湪缁撴灉鍒楃敤=IMAGE()鍑芥暟涓€閿敓鎴愶紙闇€瀹夎Excel鎻掍欢锛?/p>

鈥?strong>鈥嬫搷浣滈獙璇佺増鏈€?/strong>鈥嬶細Windows Excel 2021 / WPS 2023锛堝畨鍗?iOS鎵嬫満绔悓姝ユ祴璇曢€氳繃锛?/p>