1. Excel涓鎬庝箞鍘繪帀澶氫綑鐨勬暟鎹錛
鏁寸悊Excel琛ㄦ暟鎹鏃訛紝鏈夋椂浼氶渶瑕佸幓鎺夊瓧絎︿覆涓澶氫綑鐨勫瓧絎︼紝鐣欎笅闇瑕佺殑瀛楃︼紝鏂逛究鏁版嵁鐨勬暣鐞嗐
1銆侀栧厛瑙傚療瀛楃︿覆鐨勭壒鐐癸紝涓嶅悓鐨勭壒鐐瑰彲浠ヤ嬌鐢ㄤ笉鍚岀殑鏂規硶銆傚備笅鍥炬墍紺猴紝瀵逛簬鐗圭偣涓鐨勬儏鍐碉紝鍥犱負鏈夌浉鍚屽瓧絎︾┖鏍肩殑瀛樺湪錛屽彲浠ヤ嬌鐢ㄦ浛鎹㈡硶錛岀壒鐐逛簩鐨勬儏鍐碉紝鍥犱負瀛楃︽暟涓鏍鳳紝鏈鏂逛究鐨勬柟娉曟槸鍏寮忔硶銆
2銆佹浛鎹㈡硶錛氶【鍚嶆濅箟灝辨槸灝嗕笉闇瑕佺殑瀛楃︽浛鎹涓虹┖鐧藉氨鍙浠ョ暀涓嬫兂瑕佺殑瀛楃︺
棣栧厛鎸変笅ctrl+f鍋ュ嚭鐜鏌ユ壘鏇鎹㈠硅瘽妗嗭紝閫夋嫨鏇挎崲銆鍦鏌ユ壘鍐呭逛腑杈撳叆*+絀烘牸錛鏇挎崲涓轟腑涓嶉渶瑕佽緭鍏ヤ換浣曞唴瀹癸級錛岀劧鍚庣偣鍑誨叏閮ㄦ浛鎹㈠嵆鍙銆
3銆佹浛鎹㈡硶錛*浠ｈ〃瑕佸幓闄ょ殑閮ㄥ垎鎵鍦ㄧ殑浣嶇疆錛岀┖鏍鎸囧瓧絎︿覆涓鐩稿悓鐨勫瓧絎︼紝褰撹佸幓闄ょ殑鍐呭瑰湪宸﹁竟鏃訛紝*灝辨斁鍦ㄧ浉鍚屽瓧絎︾殑宸﹁竟錛屽綋瑕佸幓闄ょ殑鍐呭瑰湪鍙寵竟鏃訛紝*灝辨斁鍦ㄧ浉鍚屽瓧絎︾殑鍙寵竟錛屽彲鏍規嵁瀹為檯鎯呭喌濉鍐欍
4銆佸叕寮忔硶錛甯歌佺殑鍏寮忔湁left(B2:4)琛ㄧず鐣欎笅B2鍗曞厓鏍煎乏杈圭殑鍓4浣嶏紝鍜孯IGHT(B2,2)鐣欎笅B2鍗曞厓鏍煎彸杈圭殑鍚2浣銆傝繖縐嶆柟娉曢傚悎闇瑕佺暀涓嬬殑瀛楃︽暟涓鏍風殑鎯呭喌錛岄兘鏄鐣欎笅2浣嶆垨鑰呴兘鏄鐣欎笅4浣嶃
5銆佸叕寮忔硶錛褰撻渶瑕佺暀涓嬬殑瀛楃︽暟閲忎笉涓鑷存椂錛屽彲浠ヤ嬌鐢╨en(B2)錛堟眰B2瀛楃︿覆鐨勯暱搴︼級鍑芥暟榪涜岃緟鍔錛屾眰瑙ｅ嚭瀛楃︿覆鐨勬婚暱搴︾劧鍚庡噺鍘諱笉闇瑕佺殑瀛楃︿覆鐨勯暱搴︼紝灝辨槸闇瑕佺暀涓嬫潵鐨勫瓧絎︿覆闀垮害銆傝繖縐嶆柟娉曢傚悎涓嶉渶瑕佺暀涓嬬殑瀛楃︽暟涓鏍風殑鎯呭喌銆
娉ㄦ剰浜嬮」錛1銆佹浛鎹㈡硶錛屾瘮杈冮傚悎瀛楃︿覆涓鏈夌浉鍚岀殑瀛楃︽柟渚胯繘琛屽乏鍙沖尯鍒嗙殑鎯呭喌銆
2銆佸叕寮忓彂錛岃嚦灝戦渶瑕佹弧瓚抽渶瑕佺暀涓嬬殑瀛楃︽暟涓鑷存垨鑰呬笉闇瑕佺暀涓嬬殑瀛楃︽暟涓鑷翠箣涓鐨勪竴涓鏉′歡鏂瑰彲浣跨敤銆