馃毄澶嶅埗琛ㄦ牸鎬荤矘鎴愪竴鍧紵

浣犳槸涓嶆槸涔熼亣鍒拌繃杩欑鎯呭喌锛氫粠Word琛ㄦ牸閲屽鍒舵暟鎹埌Excel锛岀粨鏋滀环鏍煎拰鍗曚綅鎸ゅ湪鍚屼竴鏍硷紝鏁板瓧甯︾潃涔变竷鍏碂鐨勬牸寮忥紵涓婁釜鏈堝府璐㈠姟閮ㄥ鐞嗗搴︽姤琛紝鈥?strong>鈥?00澶氫釜琛ㄦ牸绮樺緱鎴戝樊鐐圭牳閿洏鈥?/strong>鈥嬧€斺€旀槑鏄庡湪Word閲屾暣鏁撮綈榻愮殑鏁版嵁锛屼竴澶嶅埗灏卞彉鎴?楼256.5鍏?3浠?杩欑鍥涗笉鍍忥紒

鍒厡锛岃繖灏辨暀浣犲嚑鎷涳紝鈥?strong>鈥嬭繛VBA浠ｇ爜閮戒笉鐢ㄥ鈥?/strong>鈥嬶紝灏辫兘鎶婅〃鏍兼暟鎹墥寰楀共骞插噣鍑€銆傚挶浠粠骞煎効鍥骇鍒扮帇鑰呯骇鏂规硶鎸ㄤ釜鐩橈紒

馃敡鍩虹鐗堬細琛ㄦ牸杞崲鍣ㄥぇ娉?/h3>

鍏堟潵涓湁鎵嬪氨浼氱殑缁濇椿锛侀€変腑鏁翠釜琛ㄦ牸锛岀偣鍑汇€愬竷灞€銆戔啋銆愯浆鎹负鏂囨湰銆戯紝杩欐椂鍊欎細璺冲嚭涓璇濇銆傗€?strong>鈥嬮噸鐐规潵浜嗏€?/strong>鈥嬶細涓€瀹氳閫夈€愬埗琛ㄧ銆戣€屼笉鏄钀芥爣璁帮紒

涓句釜鏍楀瓙馃尠锛?/p>

鍟嗗搧	鍗曚环	搴撳瓨
榧犳爣	楼89.5	150
閿洏	楼239	80

杞崲鍚庝細鍙樻垚锛?br/> 榧犳爣鈫捖?9.5鈫?50
閿洏鈫捖?39鈫?0

杩欐椂鍊欏叏閫夊鍒讹紝寰€Excel閲屼竴璐达紝鈥?strong>鈥嬭嚜鍔ㄥ垎鍒楁悶瀹氣€?/strong>鈥嬶紒涓婂懆鎴戠敤杩欐嫑澶勭悊渚涘簲鍟嗘姤浠峰崟锛屽師鏈1灏忔椂鐨勬椿锛?0鍒嗛挓灏变氦宸簡锛岃繕琚じ"鏁堢巼鎯婁汉"~

---

鈿¤繘闃舵妧宸э細鍏紡鎵归噺鎵掓暟鎹?/h3>

閬囧埌鍚堝苟鍗曞厓鏍艰繖绉嶅购铔惧瓙鎬庝箞鍔烇紵姣斿杩欑楝肩暅琛ㄦ牸锛?/p>

鍦板尯	绗竴瀛ｅ害	绗簩瀛ｅ害
鍗庝笢	256涓?/td>	锛堝悎骞跺崟鍏冩牸锛?/td>
	308涓?/td>

鎸変綇Alt涓嶆斁锛屽厛鐐广€愬竷灞€銆戔啋銆愰€夋嫨銆戔啋銆愰€夋嫨鍗曞厓鏍笺€戯紝鈥?strong>鈥嬪儚鍒囪眴鑵愬潡涓€鏍锋閫夋暟鍊煎尯鍩熲€?/strong>鈥嬨€傜劧鍚庢寜涓?code>Ctrl+C锛岀濂囩殑浜嬫儏鍙戠敓浜嗏€斺€旇繛鍚堝苟鍗曞厓鏍肩殑鏁版嵁閮借兘瀹屾暣澶嶅埗锛?/p>

璐村埌Excel鍚庤寰楁寜Ctrl+H锛屾妸"涓?鏇挎崲鎴愮┖鍊硷紝绔嬮┈寰楀埌骞插噣鏁板瓧銆傛垜浠姙鍏鐨勫疄涔犵敓灏忓鐢ㄨ繖鎷涳紝鈥?strong>鈥嬫妸3澶╁伐浣滈噺鍘嬬缉鍒?灏忔椂鈥?/strong>鈥嬶紝鐜板湪宸茬粡鎴愪负閮ㄩ棬绾汉鍟︼紒

---

馃缁堟瀬鏉€鍣細閭欢鍚堝苟绁炴搷浣?/h3>

濡傛灉瑕佹彁鍙栨暣涓枃妗ｉ噷鎵€鏈夎〃鏍肩殑鎸囧畾鍒楋紝杩欎釜闅愯棌鍔熻兘鑳借浣犵瑧鍑哄０锛?/p>

1. 鎶奧ord鏂囨。鍙﹀瓨涓恒€愬崟涓枃浠剁綉椤?*.mht)銆?/li>
2. 鐢‥xcel鎵撳紑杩欎釜鏂囦欢锛屸€?strong>鈥嬫墍鏈夎〃鏍艰嚜鍔ㄥ彉鎴愮嫭绔媠heet鈥?/strong>鈥?/li>
3. 鍦≒ower Query閲岀偣銆愬悎骞舵煡璇€戯紝鍞板敯鍞板氨姹囨€绘垚鎬昏〃

涓婁釜鏈堝鐞嗗勾搴︽€荤粨鎶ュ憡鏃讹紝30澶氫釜閮ㄩ棬鐨勪笟缁╄〃鏍硷紝鐢ㄨ繖涓柟娉曗€?strong>鈥?0鍒嗛挓鐢熸垚姹囨€诲ぇ琛ㄢ€?/strong>鈥嬨€傝€佹澘绔潃鍜栧暋杩囨潵宸℃煡鏃讹紝鎴戝凡缁忓湪鍒峰井鍗氫簡锛堝槝鈥斺€旓級

---

馃鐏甸瓊鎷烽棶鐜妭

鈥?strong>鈥婹锛氬甫鍏紡鐨勮〃鏍兼€庝箞鐮达紵鈥?/strong>鈥?br/> A锛氬厛鎸?code>Ctrl+A鍏ㄩ€夛紝鍐嶇媯鎸?code>Ctrl+6锛堣繖缁勫悎閿垜鎵句簡3骞达紒锛夛紝鎵€鏈夊叕寮忕灛闂村彉闈欐€佹暟鍊?/p>

鈥?strong>鈥婹锛氳〃鏍奸噷鏈夊浘鐗囧拫鏁达紵鈥?/strong>鈥?br/> A锛氳浆鎹㈠墠鍏堟寜浣?code>Ctrl鎸ㄤ釜鐐瑰嚮鍥剧墖鍒犳帀锛屾垨鑰呯敤銆愭浛鎹€戔啋銆愮壒娈婃牸寮忋€戔啋銆愬浘褰€戞壒閲忓垹闄?/p>

馃搳鏁版嵁鏆村嚮

瀵规瘮涓嬩笉鍚屾柟娉曠殑鏁堢巼宸窛锛?/p>

鎸夋瘡澶╁鐞?娆¤绠楋紝鈥?strong>鈥嬩竴骞磋兘鐪佷笅146灏忔椂鈥?/strong>鈥嬶紝澶熺湅瀹屻€婄攧瀣涗紶銆?銆婂鎳夸紶銆?銆婂欢绂ф敾鐣ャ€嬭繕鏈夊墿锛?/p>

馃挕鐙閬垮潙鎸囧崡

• 閬囧埌甯?楼12.3涓?杩欑澶嶅悎鍗曚綅锛屽厛鐢ㄩ€氶厤绗︽浛鎹細楼([0-9.])涓?/code>鈫?code>\1 * 10000
• 鍗冨垎浣嶉€楀彿浼氬彉鎴愭枃鏈牸寮忥紝鍦‥xcel閲岀敤=VALUE(SUBSTITUTE(A1,",",""))绉掕浆鏁板瓧
• 閲嶈鏂囨。鎿嶄綔鍓嶏紝璇烽粯蹇典笁閬嶅彛璇€锛氫繚瀛橈紒淇濆瓨锛佷繚瀛橈紒锛堝埆闂垜涓轰粈涔堝己璋冭繖涓煒級

涓嬫鍐嶇湅鍒板瘑瀵嗛夯楹荤殑Word琛ㄦ牸锛岃寰楀畠浠棭灏辨槸寰呭鐨勭緮缇婂暒锛侀『鎵嬬偣涓敹钘忥紝鍗囪亴鍔犺柂璇翠笉瀹氬氨鐢ㄤ笂浜嗗憿~