excel中如何在不知道字符串长度的情况下 从右到左截取单个字符串 200分简单问题 从excel中从右开始截取指定字符串
excel \u4ece\u5de6\u8fb9\u7b2c\u4e00\u4e2a\u201c-\u201d\u622a\u53d6\u53f3\u8fb9\u5168\u90e8\u5b57\u7b26\u4e32
\u5728B3\u8f93\u5165 =MID(A3\uff0c7\uff0c100)
\u9700\u8981\u8bf4\u660e\u4e0b\uff0c\u5bf9\u4e8e\u6570\u5b57\uff0c\u5b57\u6bcd\u800c\u8a00\u5b57\u7b26\u4e0e\u5b57\u8282\u957f\u4e00\u6837\uff0c\u4f46\u5bf9\u4e8e\u6c49\u5b57\u800c\u8a00\u5b57\u7b26\u957f\u662f\u5b57\u8282\u957f\u76842\u500d\u3002
\u5982\u679c\u4f60\u662f\u53bb\u6c49\u5b57\u9700\u8981\u8003\u8651\u4e0b\u8fd9\u70b9\uff1a
\u5168\u90e8\u663e\u793a
RIGHT
\u8bf7\u53c2\u9605
\u4e5f\u5e94\u7528\u4e8e\uff1a
RIGHTB
RIGHT \u6839\u636e\u6240\u6307\u5b9a\u7684\u5b57\u7b26\u6570\u8fd4\u56de\u6587\u672c\u5b57\u7b26\u4e32\u4e2d\u6700\u540e\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u7b26\u3002
RIGHTB \u6839\u636e\u6240\u6307\u5b9a\u7684\u5b57\u7b26\u6570\u8fd4\u56de\u6587\u672c\u5b57\u7b26\u4e32\u4e2d\u6700\u540e\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u7b26\u3002\u6b64\u51fd\u6570\u7528\u4e8e\u53cc\u5b57\u8282\u5b57\u7b26\u3002
\u8bed\u6cd5
RIGHT(text,num_chars)
RIGHTB(text,num_bytes)
Text \u662f\u5305\u542b\u8981\u63d0\u53d6\u5b57\u7b26\u7684\u6587\u672c\u5b57\u7b26\u4e32\u3002
Num_chars \u6307\u5b9a\u5e0c\u671b RIGHT \u63d0\u53d6\u7684\u5b57\u7b26\u6570\u3002
Num_bytes \u6307\u5b9a\u5e0c\u671b RIGHTB \u6839\u636e\u5b57\u8282\u6240\u63d0\u53d6\u7684\u5b57\u7b26\u6570\u3002
\u8bf4\u660e
Num_chars \u5fc5\u987b\u5927\u4e8e\u6216\u7b49\u4e8e 0\u3002
\u5982\u679c num_chars \u5927\u4e8e\u6587\u672c\u957f\u5ea6\uff0c\u5219 RIGHT \u8fd4\u56de\u6240\u6709\u6587\u672c\u3002
\u5982\u679c\u5ffd\u7565 num_chars\uff0c\u5219\u5047\u5b9a\u5176\u4e3a 1\u3002
\u793a\u4f8b (RIGHT)
\u5982\u679c\u60a8\u5c06\u793a\u4f8b\u590d\u5236\u5230\u7a7a\u767d\u5de5\u4f5c\u8868\u4e2d\uff0c\u53ef\u80fd\u4f1a\u66f4\u6613\u4e8e\u7406\u89e3\u8be5\u793a\u4f8b\u3002
\u64cd\u4f5c\u65b9\u6cd5
\u521b\u5efa\u7a7a\u767d\u5de5\u4f5c\u7c3f\u6216\u5de5\u4f5c\u8868\u3002
\u8bf7\u5728\u201c\u5e2e\u52a9\u201d\u4e3b\u9898\u4e2d\u9009\u53d6\u793a\u4f8b\u3002\u4e0d\u8981\u9009\u53d6\u884c\u6216\u5217\u6807\u9898\u3002
\u4ece\u5e2e\u52a9\u4e2d\u9009\u53d6\u793a\u4f8b\u3002
\u6309 Ctrl+C\u3002
\u5728\u5de5\u4f5c\u8868\u4e2d\uff0c\u9009\u4e2d\u5355\u5143\u683c A1\uff0c\u518d\u6309 Ctrl+V\u3002
\u82e5\u8981\u5728\u67e5\u770b\u7ed3\u679c\u548c\u67e5\u770b\u8fd4\u56de\u7ed3\u679c\u7684\u516c\u5f0f\u4e4b\u95f4\u5207\u6362\uff0c\u8bf7\u6309 Ctrl+`\uff08\u91cd\u97f3\u7b26\uff09\uff0c\u6216\u5728\u201c\u5de5\u5177\u201d\u83dc\u5355\u4e0a\uff0c\u6307\u5411\u201c\u516c\u5f0f\u5ba1\u6838\u201d\uff0c\u518d\u5355\u51fb\u201c\u516c\u5f0f\u5ba1\u6838\u6a21\u5f0f\u201d\u3002
1
2
3
A
\u6570\u636e
\u9500\u552e\u4ef7\u683c
\u80a1\u7968\u6570
\u516c\u5f0f \u8bf4\u660e\uff08\u7ed3\u679c\uff09
=RIGHT(A2,5) \u7b2c\u4e00\u4e2a\u5b57\u7b26\u4e32\u7684\u6700\u540e 5 \u4e2a\u5b57\u7b26 (Price)
=RIGHT(A3) \u7b2c\u4e8c\u4e2a\u5b57\u7b26\u4e32\u7684\u6700\u540e\u4e00\u4e2a\u5b57\u7b26 (r)
\u793a\u4f8b (RIGHTB)
=RIGHTB("",2) \u7b49\u4e8e\u201c\u90fd\u201d
\u795d\u4f60\u6210\u529f\uff01
用取值函数RIGHT，格式如下：
=RIGHT（数据，第几位开始，取几位）
right(A1,1)
绛旓細鍦‥xcel涓鎻愬彇涓涓崟鍏冩牸涓殑鏌愬嚑涓瓧绗﹂氬父闇瑕佷娇鐢瀛楃涓鍑芥暟锛屼緥濡侺EFT銆丷IGHT鎴朚ID銆備互涓嬫槸濡備綍浣跨敤杩欎簺鍑芥暟鏉ユ彁鍙栧崟鍏冩牸涓殑鏌愬嚑涓瓧绗︼細1. LEFT鍑芥暟锛歀EFT鍑芥暟杩斿洖鏂囨湰瀛楃涓茬殑宸﹁竟瀛楃銆傛瘮濡傦紝LEFT(A2;3)灏嗚繑鍥炲崟鍏冩牸A2涓墠涓変釜瀛楃銆傚叾涓紝鈥3鈥濅唬琛ㄨ鎻愬彇鐨勫瓧绗︽暟锛屽彲浠ヨ嚜琛岃皟鏁磋繖涓暟瀛椼2. ...
绛旓細Excel涓鍙互鍒╃敤蹇熷～鍏呯殑鏂规硶锛屽疄鐜颁粠鏌愪覆鏈夎寰嬬殑瀛楃涓涓彁鍙栨煇娈靛瓧绗︿覆鐨勫姛鑳姐傝蒋浠剁増鏈細Office2013 鏂规硶濡備笅锛1.Excel涓瑼鍒楁湁鏁版嵁濡備笅鍥炬墍绀猴紝鐜板湪瑕佹彁鍙栤/"鍓嶇殑鏁版嵁锛涘彲浠ョ湅鍒癆鍒楀崟鍏冩牸涓兘鍙湁涓涓/鈥滐紝鍥犳瀹屽叏鍙互浣跨敤蹇熷～鍏呯殑鏂规硶锛屾柟渚垮揩鎹峰湴鎻愬彇鎸囧畾瀛楃涓层2.鐜板湪B1涓緭鍏ヨ浠嶢1...
绛旓細find()鍑芥暟鏄細杩斿洖鏌愬瓧绗﹀湪涓瀛楃涓涓殑浣嶇疆銆傝屼笉鏄煡鎵句竴涓瓧绗︿覆鍦ㄤ竴涓暟鎹尯鍩熺殑浣嶇疆銆傜敤缂栬緫---鏌ユ壘---1,2浜屾隘涔欑兎---鍏ㄩ儴鏌ユ壘銆傚璇濇涓氨鏄剧ず鏁版嵁鐨勪綅缃簡銆傚苟鏄剧ず鎵惧埌鐨勬暟閲忋傚叕寮 =COUNTIF(A1锛欰15锛孌1)锛屽氨杩斿洖A鍒楁湁澶氬皯涓瓑浜嶥1鐨勪簡銆
绛旓細濡傛灉 鏄煡鎵惧崟鍏冩牸鍐呮槸涓嶆槸鏈夋煇涓瀛楃涓锛屽彲浠ョ敤find()涓涓崟鍏冩牸涓涓崟鍏冩牸鐨勬煡鎵炬暟鎹紝娌℃湁鐨勬樉绀洪敊璇紝鏈夌殑鏄剧ず鏁板瓧銆傚鏋滄槸鐪嬫煇涓鍖哄煙鏈夋病鏈夋煇涓瓧绗︿覆锛屽彲浠ョ敤countif()濡傛灉鎯宠揪鍒颁袱绉嶅姛鑳藉湪涓鍧楋紝鍙互鐢ㄦ槦鍙疯繖涓氶厤绗︹*鈥
绛旓細1銆佹湰娆℃紨绀轰娇鐢ㄧ殑杞欢涓Excel鐢靛瓙琛ㄦ牸锛屼娇鐢ㄧ殑鐗堟湰涓篛ffice 2016瀹跺涵鍜屽鐢熺増銆2銆侀鍏堟墦寮鐢靛瓙琛ㄦ牸锛屾牴鎹棶棰樻弿杩拌緭鍏ョ敤浜庢紨绀哄湪鏂囨湰鎸囧畾浣嶇疆娣诲姞绗﹀彿鐨勬搷浣溿3銆佹彃鍏ュ嚱鏁扳=REPLACE(A1,4,0,"-")鈥濓紝璇ュ嚱鏁拌〃绀轰粠A1鍗曞厓鏍肩殑鏂囨湰涓紝鎵惧埌绗洓涓綅缃紝鏇挎崲鎴愨-鈥濄4銆佽緭鍏ュ畬鎴愮偣鍑诲洖杞﹀彲浠ョ湅鍒板凡缁忓皢...
绛旓細鍏蜂綋鎿嶄綔鏂规硶濡備笅锛1.left鍑芥暟鐢ㄦ潵瀵瑰崟鍏冩牸鍐呭杩涜鎴彇銆備粠宸﹁竟绗竴涓瀛楃寮濮嬫埅鍙栵紝鎴彇鎸囧畾鐨勯暱搴︺2.left鍑芥暟鐨勮娉曟牸寮 =left(text,num_chars)锛宼ext浠ｈ〃鐢ㄦ潵鎴彇鐨勫崟鍏冩牸鍐呭锛宯um_chars浠ｈ〃浠庡乏寮濮嬫埅鍙栫殑瀛楃鏁般3.濡傚浘鎵绀猴紝瀵逛簬涓闀夸覆鍦板潃涓彁鍙栫渷浠斤紝杈撳叆鍏紡=LEFT(A1,3)锛屽湪A1涓粠宸︽彁鍙3...
绛旓細Function 鎵句綅缃(a As String, c As String)b = Split(a, "_", -1, 1)For i = 0 To UBound(b) If c = b(i) Then 鎵句綅缃 = i + 1NextIf 鎵句綅缃 = 0 Then Dim arr(1 To 6000, 1 To 1) If 鎵句綅缃 = 0 Then arr(1, 1) = "c" If arr(1, 1) =...
绛旓細鍦‥xcel涓寮曠敤鍗曞厓鏍煎唴鐨勯儴鍒嗘枃瀛椾篃鏄湪宸ヤ綔涓粡甯镐細閬囧埌鐨勬儏鍐碉紝杩欓噷鍙互浣跨敤鍑芥暟锛屽垎涓轰笁閮ㄥ垎鏉ヨ锛氫竴銆丩EFT鍑芥暟-寮曠敤鍗曞厓鏍煎唴鍓嶉儴鍒嗘枃瀛 涓銆丩EFT鍑芥暟-寮曠敤鍗曞厓鏍煎唴鍓嶉儴鍒嗘枃瀛 鎴戜滑濡傛灉闇瑕佸紩鐢ㄥ崟鍏冩牸鍓嶅崐閮ㄥ垎鏂囧瓧锛岄偅鍙娇鐢↙EFT鍑芥暟锛汱EFT(text,[num_chars])=LEFT(瀛楃涓浣嶇疆,瀛楃闀垮害)锛涘涓婂浘闇瑕...
绛旓細绗竴绉嶆槸浠庡浐瀹氫綅缃彃鍏ョ壒瀹氬瓧绗︿覆锛堜緥瀛愰噷闈㈠亣璁炬槸浠庣涓変綅寮濮嬶紝鎵浠ュ叕寮忛噷闈㈢殑鏁板瓧鏄3锛夈愬叕寮忎负绾㈣壊瀛椾綋閮ㄥ垎锛夌浜岀鏄粠瀛楃涓查噷闈鎸囧畾鐨勫瓧绗﹀悗闈㈡彃鍏ュ瓧绗︿覆锛堝叕寮忓湪缂栬緫鏍忛噷闈級PS锛氫緥瀛愰噷闈鍒楁槸闇瑕佹彃鍏ョ殑鐗瑰畾瀛楃涓
绛旓細鍦‥XCEL琛ㄦ牸澶勭悊涓紝甯稿父闇瑕鍦ㄥ瓧绗︿覆涓彁鍙栭儴鍒嗗瓧绗︼紝浠ヨ繘琛屼笅涓姝ュ鐞嗭紝鏍规嵁鎻愬彇浣嶇疆鐨勪笉鍚岋紝鐩稿簲鐨勫嚱鏁版湁LEFT銆丮ID銆丷IGHT銆俁IGHT鍦ㄨ嫳鏂囦腑鏈甯歌鐨勬剰鎬濇槸鈥滃悜鍙炽佸彸杈光濓紝EXCEL涓RIGHT灏辨槸鏍规嵁鎵鎸囧畾鐨勫瓧绗︽暟杩斿洖鏂囨湰瀛楃涓蹭腑鍙充晶鑻ュ共涓瓧绗︾殑鍑芥暟锛汻IGHT鍑芥暟鏈変袱涓弬鏁帮紝璇硶涓猴細RIGHT(text,[num_chars...
