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

[µo°Ý] ¦p¦ó±Æ°£­^¤å¦r¥À¤Î"-"¦r²Å¨ú¥þ³¡¼Æ¦r?

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2020-7-8 15:52 ½s¿è

°}¦C¤½¦¡(¤TÁä):
=MID(LOOKUP(,-(1&SUBSTITUTE(MID(A1,MATCH(,MID(A1&1,ROW($1:$99),1)*0,),ROW($1:$15)),"-",))),3,15)

=MID(LOOKUP(,-(1&SUBSTITUTE(MID(A1,MIN(FIND(ROW($1:$10)-1,A1&1/17)),ROW($1:$15)),"-",))),3,15)

TOP

¥u­n¼Æ¦r
.Pattern = "[^0-9]"

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD