ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] §å¸¹ºI¨ú

[µo°Ý] §å¸¹ºI¨ú

½Ð°Ý¦p¤U¹Ï¢ÑÄ檺§å¸¹¡A·Q­n¦b¢ÐÄæ±a¥X¡¨¡Ð¢°¡¨©Î¬O¡¨¡]¡¨«eªº¼Æ¦r¡A¸Ó¦p¦ó±a¨ç¼Æ©O¡H



¦p¢ÑÄ檺ABC1907-1¡BABC1907-1(1/2)¡BABC1907¡A¦b¢ÐÄæ¬Ò±a¥XABC1907¡C
ªþ¥óªº¤½¦¡¥u¦³±a¡¨¡]¡¨«eªº¡C¦ý¦b¢ÐÄ椤ABC1907-1¡BABC1907³£±a¤£¥X¨Ó¡C
¥d¦í¤F¡A·Q¤£³q¸Ó«ç»ò±a¡C

½Ð°Ý¦³¤èªk¥i¥H±a¥X¨Ó¶Ü¡HÁÂÁ¡C
§å¸¹.zip (7.91 KB)

=IF(ISERROR(IF(ISERROR(MID(C2,1,LEN(C2)-(LEN(C2)-SEARCH("-1(",C2)+1))),MID(C3,1,LEN(C3)-(LEN(C3)-SEARCH("-1",C3)+1)),MID(C2,1,LEN(C2)-(LEN(C2)-SEARCH("-1(",C2)+1)))),C2,IF(ISERROR(MID(C2,1,LEN(C2)-(LEN(C2)-SEARCH("-1(",C2)+1))),MID(C3,1,LEN(C3)-(LEN(C3)-SEARCH("-1",C3)+1)),MID(C2,1,LEN(C2)-(LEN(C2)-SEARCH("-1(",C2)+1))))
ù

TOP

=LEFT(C2,FIND("-",C2&"-")-1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¨ú¥ô¦ó²Å¸¹«e¦r¦ê
://blog.xuite.net/hcm19522/twblog/588621908
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# rouber590324
¦^´_ 3# hcm19522

ÁÂÁ¨â¦ì¦^ÂСC
«Ü©êºp¡A°ÝÃD¦³­Ó¦a¤è¨S¼g²M·¡¡C
§å¸¹¦³¥i¯à¬OABC1907-1¡BAB-1907-1¡BAB-1907¡BAB-1907(1/2)¡C
§Æ±æ¯à±a¥XABC1907-1¡A¤@¶}©l¼g¿ù¡A¼g¦¨ABC1907¡C
©Ò¥H¦bAB-1907-1¡A·|±a¦¨AB¡C

¯u¤£¦n·N«ä¡A°ÝÃD¨S¼g²M·¡¡C

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD