- ©«¤l
- 824
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 904
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 10,7
- ³nÅ骩¥»
- 2019,2013,2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2023-12-24
|
¦^´_ luhpro
¤j¤j±z¦n §Ú·Qn½Ð°Ý¤@¤U
©w¸q¥H¤U¨âÓ¬On°µ¬Æ»òªºªü?? ¬Ý¤£¤ÓÀ´ ¥i¥H¸ÑÄÀ³oÓµ{ ...
s13983037 µoªí©ó 2014-11-23 14:03
vA = Split([A1])
¹ïÀx¦s®æ [A1] ¸Ìªº¦r¦ê°µ¤Á³Î, ¥HªÅ®æ¬°¤Á³ÎÂI, ¤Á³Î¥X¨Óªº¤l¦r¦ê¨Ì§Ç©ñ¦b VA °}¦C¤º.
iA = UBound(vA)
Àx¦s°j°é³B²z®Éªº³Ì¤jÈ(§Y¥Ø«e¤@ºû°}¦C VA ¤º¤¸¯ÀªºÓ¼Æ)
¦^´_ luhpro
¤j¤j±z¦n §Ú¥i¯à¨S¦³ªí¹F±o«Ü¦n ¨ä¹ê§Ú¬O·Q§Ë¦¨
¹ï¦P¤@ÓÀx¦s®æ¶}åªR ªþ»\¤W¥h¤] ...
s13983037 µoªí©ó 2014-11-23 14:33
¬Ý¤£À´.
§A¬On¥H ªÅ®æ °µ¬°¤À³Îªº¨Ì¾Ú?
Y¬O, ¤Wzµ{¦¡´N¤w¹ê²{.
ÁÙ¬O©T©w¤å¦rªø«×°µ¬°¤À³Îªº¨Ì¾Ú?
¥i°Ñ·Ó©³¤U¨ç¼Æ©w¸q§ì¨ú§Anªº¦r¦ê
A=Left(sStr, X) ' A¦r¦ê³]¬° sStr ¦r¦ê±q¥ªÃäºâ°_ X Ó¦r
A=Mid(sStr, B, C) ' A¦r¦ê³]¬° sStr ¦r¦êªº²Ä B Ó¦r¶}©l¨ú C Ó¦r
A=Right(sStr, D) ' A¦r¦ê³]¬° sStr ¦r¦ê±q¥kÃäºâ°_ D Ó¦r |
|