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

[µo°Ý] Âà´«¤é´Á®æ¦¡

[µo°Ý] Âà´«¤é´Á®æ¦¡

¥»©«³Ì«á¥Ñ papaya ©ó 2020-11-25 05:04 ½s¿è

Âà´«¤é´Á®æ¦¡.rar (1.83 KB)

·Q±NEÄ檺¤é´Á®æ¦¡¡AÂà´«¦¨¦p¦PAÄ檺¤é´Á®æ¦¡¡C

½Ð°Ý¡J­n¦p¦ó¾Þ§@©Î¤U¤½¦¡¡H
ÁÂÁ¡I

=SUBSTITUTE(E2,"(","(¶g")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

#2 ´£¨Ñ¤F¤å¦r®æ¦¡, §Ú°µ­È, ¦ý¤£ª¾¨ì2003¦³¨S¦³¨ç¼Æ Iferror ©M Datevalue
  1. =IFERROR(DATEVALUE(LEFT(E2,(FIND("/",E2,6)+2))),DATEVALUE(LEFT(E2,(FIND("/",E2,6)+1))))
½Æ»s¥N½X

TOP

ÁÂÁ¤G¦ì¥ý¶iªº¸Ñµª¡C·P®¦

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD