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

[µo°Ý] substitute¥i¥H¥Î°}¦C¶Ü

[µo°Ý] substitute¥i¥H¥Î°}¦C¶Ü

SUBSTITUTE(J5,{"À\¶O","¼B¼wµØ","¾¤©ú".....},"")
§Ú¥»¨Ó·Q¥Î¤W­±ªº¤è¦¡±N²Å¦Xªºµ¹§ï¦¨ªÅ¥Õ
¦pªG»¡³o¦U¨ç¼Æ¨S¿ìªk³o¼Ë¥Î
¥i¥H¥Î¨ä¥L¨ç¼Æ¹F¨ì¶Ü
¥Ø«e·Q¨ì¬O¥Îvba ¥h¶]


·s¼WMicrosoft Excel ¤u§@ªí (2).rar (1.42 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"À\¶O",""),"¼B¼wµØ",""),"¾¤©ú","")

TOP

¦^´_ 2# ANGELA


    ÁÂÁª©¥D¦^´_
   ¬Ý¨Ó¥Îvba·|¤ñ¸û§Ö
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

½Ð±Ð¤@­Ó«D±`§C¶¥ªº°ÝÃD~~~
§Ú¦Û¤v§â¤½¦¡§ï±¼¤F!!!ÁöµM¥i¥H¥Î~¦ý§Ú¤£ª¾¹D¤°»ò«á­±­n¦h³o»ò¦h­Ó"",""
¦pªþ¹Ï©ÒÅã¥Üªº~¤Ï¶Âªº¦a¤è¬O§ÚªººÃ°Ý...§Ú¦pªG§R±¼~¥L´N¤£¯à°õ¦æ³o­Ó¤½¦¡....
¦ý§Ú¦n©_ªº¬O.....§Ú¥u·Q­n§R±¼.JPG   4­Ó¦r..¬°¤°»ò«á­±­n¦A¥´³o»ò¦h¤Ï¶Âªº°Ï¶ô?
SofyShih

TOP

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

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD