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

¨ú¥XÂù¤Þ¸¹¤¤ªº­È~~

¨ú¥XÂù¤Þ¸¹¤¤ªº­È~~

Àx¦s®æ¤¤ªº­È¬°¦r¦ê¦p¤U
142,"10:30:00","3,885","626"
¨Ï¥ÎMID¨ç¼Æ¥Ñ©ó"3,885',"626"ªº¦r¦êªø«×¦³¥i¯à§ïÅÜ¡A¦³®ÉµLªk·Ç½T
¦pªG¨Ï¥ÎSplit¨ç¼Æ¥H³r¸¹¬°¤À¹j²Å¸¹¡A¤S¹J¨ì3,885·|¤@¤À¬°¤G¡A¤£·Q±o¨ìªºµ²ªG
¨Ï¥Îreplace¨ç¼Æ¤S¸I¨ì¸Ó¦ºªºÂù¤Þ¸¹¡AµLªk¨ú¥N±¼~¯u¤£ª¾¹D¦p¦ó¬O¦n~¨D°ª¤âÀ°¦£¸Ñ¨M

¥»©«³Ì«á¥Ñ infoverdad ©ó 2011-8-13 22:23 ½s¿è

¦^´_ 1# hsiaohsien


    ¸Õ¸Õ¥Î¨ú¥Nªº¤è¦¡:
¨Ò¦p¡G±N"¨ú¥N¦¨#, ³Ì²×¥Øªº¬O±N¸ê®Æ¾ã²z¦¨¥H#°Ï¹jªº§Î¦¡,¦A§Q¥Î¸ê®Æ­åªR.
bbb.gif

TOP

¦^´_ 1# hsiaohsien
  1. Sub nn()
  2. a = Split(Replace(Mid([A1], 1, Len([A1]) - 1), """,", ","), ",""")
  3. [B1].Resize(, UBound(a) + 1) = a
  4. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD