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

[µo°Ý] ²Ä¤G­ÓªÅ®æ¨ú¯S©w¤å¦r

[µo°Ý] ²Ä¤G­ÓªÅ®æ¨ú¯S©w¤å¦r

¦U¦ì:

31/3/2016 W1703025 AGILITY LOGISTICS LTD HK$1,805.70 HK$1,805.70

½Ð°Ý¦³¤°»ò¤èªk¥i¥Hset formula ¥u¨ú¤å¦r"AGILITY LOGISTICS LTD"©O??, ÁÂÁÂ

{=MID(A2,SMALL(IF(MID(A2,ROW($1:$99),1)=" ",ROW($1:$99)),2)+1,FIND("LTD",A2)-SMALL(IF(MID(A2,ROW($1:$99),1)=" ",ROW($1:$99)),2)+1)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD