ä¸ãæªåExcelå符串çé¨åå符ï¼æ们å¯ä»¥ä½¿ç¨MidãLeftãRightçå½æ°ä»é¿å符串å
è·åä¸é¨åå符ã
ããâ LEFTå½æ°ï¼
ããLEFT(text,num_chars)
ããTextæ¯å
å«è¦æåå符çææ¬ä¸²ãNum_charsæå®è¦ç±LEFT ææåçå符个æ°ï¼è¯¥å½æ°ä»å·¦è¾¹å¼å§æåå符ã
ããâ¡MIDå½æ°ï¼
ããMID(text,start_num,num_chars)
Textæ¯å
å«è¦æåå符çææ¬ä¸²ãStart_numæ¯ææ¬ä¸è¦æåç第ä¸ä¸ªå符çä½ç½®ãnum_charsæ¯è¦æåçå符个æ°ï¼ä»å·¦è¾¹å¼å§æåå符ã
ä¾ï¼å¦B1åå
æ ¼æ¯ABC123Dï¼ç°å¨è¦æåå
¶ä¸ç123å°C1éå¨C1è¾å
¥å
¬å¼ï¼=MID(B1,4,3)
ããâ¢RIGHTå½æ°ï¼
ããRIGHT(text,num_chars)
ããTextæ¯å
å«è¦æåå符çææ¬ä¸²ãNum_charsæå®å¸æ RIGHT æåçå符个æ°ã该å½æ°ä»å³è¾¹å¼å§æåå符ã
äºã(Findå½æ°)
ããæ¤æç¨æ¥å¯¹åå§æ°æ®ä¸æ个å符串è¿è¡å®ä½ï¼ä»¥ç¡®å®å
¶ä½ç½®ãå 为该æè¿è¡å®ä½æ¶ï¼æ»æ¯ä»æå®ä½ç½®å¼å§ï¼è¿åæ¾å°ç第ä¸ä¸ªå¹é
å符串çä½ç½®ï¼èä¸ç®¡å
¶åæ¯å¦è¿æç¸å¹é
çå符串ï¼æç¹åçåæ¸è±¡ï¼æ¸å°åªå°±è¯´åªï¼å æ¤ååâçåæ¸è±¡âã
ãã使ç¨è¯æ³
ããFIND(find_text,within_text,start_num)
ããFind_text æ¯è¦æ¥æ¾çææ¬ã
ããWithin_text æ¯å
å«è¦æ¥æ¾ææ¬çææ¬ã
ããStart_num æå®å¼å§è¿è¡æ¥æ¾çå符ãwithin_text ä¸çé¦å符æ¯ç¼å·ä¸º 1 çå符ãå¦æå¿½ç¥ start_numï¼åå设å
¶ä¸º 1ã
ãã注æï¼
ããä½¿ç¨ start_num å¯è·³è¿æå®æ°ç®çå符ãä¾å¦ï¼åå®ä½¿ç¨ææ¬å符串âAYF0093.YoungMensApparelâï¼å¦æè¦æ¥æ¾ææ¬å符串ä¸è¯´æé¨åç第ä¸ä¸ªâYâçç¼å·ï¼åå¯å° start_num 设置为 8ï¼è¿æ ·å°±ä¸ä¼æ¥æ¾ææ¬çåºåå·é¨åãFIND å°ä»ç¬¬ 8 个å符å¼å§æ¥æ¾ï¼èå¨ä¸ä¸ä¸ªå符å¤å³å¯æ¾å° find_textï¼äºæ¯è¿åç¼å· 9ãFIND æ»æ¯ä» within_text çèµ·å§å¤è¿åå符ç¼å·ï¼å¦æ start_num å¤§äº 1ï¼ä¹ä¼å¯¹è·³è¿çå符è¿è¡è®¡æ°ã
ããå¦æ find_text æ¯ç©ºææ¬ ()ï¼å FIND åä¼è¿åæ°å¼1ã
ããFind_text ä¸ä¸è½å
å«éé
符ã
ããå¦æ within_text ä¸æ²¡æ find_textï¼å FINDè¿åéè¯¯å¼ #VALUE!ã
ããå¦æ start_num ä¸å¤§äº 0ï¼å FINDè¿åéè¯¯å¼ #VALUE!ã
ããå¦æ start_num å¤§äº within_text çé¿åº¦ï¼å FIND è¿åéè¯¯å¼ #VALUE!ã
ããåºç¨ç¤ºä¾ï¼
ããä¸å¾ä¸ï¼å¯¹å«æä¸åå°æ¹çæ°æ®ï¼å©ç¨âFindâå½æ°ï¼é常ç®åå°ç¡®å®äºâçâåºç°çä½ç½®ã
ãã详ç»è§£é
ããå
¬å¼â=FIND(ç,A2)âä¸ï¼âçâ表示è¦æ¥æ¾çææ¬ä¸ºâçâï¼ï¼å®é
使ç¨ä¸ï¼ä¹å¯ä»¥å¾é¿çä¸ä¸²å符ï¼ãè¦æ¾æ¥æ¾ç对象æ¯A2åå
æ ¼çå
容â广ä¸çä¸èå¸ä¸ååºâ¦âï¼å 为没ææå®èµ·å§ä½ç½®ï¼æ以系ç»ä»ç¬¬ä¸ä½å¼å§ãè¿åçâ3âï¼è¡¨ç¤ºâçâåå¨ç¬¬ä¸ä½ãèâé»é¾æ±çåå°æ»¨å¸â¦âåè¿å4ã
ããä¸Find类似ï¼Searchå½æ°ä¹æç¸åçåè½ãå®ä»¬çåºå«æ¯ï¼Findåºå大å°åï¼èSearchä¸å大å°åï¼å½è¢«æ¥æ¾çææ¬ä¸ºè±ææ¶ï¼ã
ããå¦å¤ï¼å¨Excelä¸ï¼å¯¹ææ¬è¿è¡å¤ççå¾å¤å½æ°é½æä¾äºä¸ä¸ªç¹å«ç¨æ¥å¤çååèå符ï¼å¦ä¸æï¼æ¥æï¼çå½æ°ï¼ä¸è¬æ¯å¨åå½æ°åå âBâï¼å¦FIND, å°±æä¸ä¸ªFINDBãä¹å讲è¿çLEFT,ç¸å¯¹åºçå°±æ¯LEFTBçãå
¶å®ï¼æ们å¨å®é
åºç¨ä¸ï¼ä½¿ç¨ä¸å¸¦âBâçå½æ°å°±è¶³å¤äºãå¦æä½ æ³ä½¿ç¨å¸¦âBâçå½æ°ï¼åè¦ç¹å«æ³¨æï¼å°¤å
¶æ¯å¨ç»åè¿ç¨å½æ°æ¶ï¼å
¶ä¸ä¸ä¸ªå½æ°ä½¿ç¨å¸¦âBâçå½¢å¼ï¼åå
¶å®æ带âBâå½¢å¼çå½æ°ï¼å
¨é¨é½è¦ä½¿ç¨å
¶å¸¦âBâçå½¢å¼ï¼å¦åç»ææå¯è½æ¯éçã
计ç®å符串çé¿åº¦ï¼lenï¼
å¨Excelä¸ï¼å¦æè¦è®¡ç®å符串çé¿åº¦ï¼å¯ä»¥ä½¿ç¨LENå½æ°è®¡ç®å符串çé¿åº¦ãExcel2007å¯ä½¿ç¨LENå½æ°è®¡ç®å符串çé¿åº¦ã
å¦ä¸å¾æ示ï¼å¨B2åå
æ ¼è¾å
¥å
¬å¼ï¼
=LEN(A2)
æå车é®å³å¯è®¡ç®å符串çé¿åº¦ï¼è¿åå符串çé¿åº¦ã
Excel2007å¯ä½¿ç¨LENå½æ°è®¡ç®å符串çé¿åº¦ã
å®ä¾ä¸ï¼
æ¯å¦æä¸é¢ææ¬ï¼
202.96.119.221:80@HTTP$1.2#æµæ±çéåå¸
ææ³æªå$åçå符ï¼é¿åº¦ä¸åºå®ï¼ï¼å¦ä½å®ç°ï¼
âæ°æ®å¨Aå åBåæ°æ®ä¸º=MID(A1,1,FIND("$",A1,1)-1)
温馨提示:答案为网友推荐,仅供参考