- ©«¤l
- 12
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2014-3-22
- ³Ì«áµn¿ý
- 2020-5-27
|
VBA¤½¦¡""Åã¥Ü°ÝÃD
¤j®a¦n
§Ú·Q±NA1ªºÀx¦s®æ³]¬°¥H¤U¤½¦¡
Worksheets("Main").Range("A1").Formula = "=IF(RIGHT($C1,6)="000000","-",LEFT($C1,6))"
¥i¬O" "ªº¸Ì±ÁÙ¦³""·|¥X²{¿ù»~
½Ð°Ýn«ç¼Ë¤~¯à³]©w¤½¦¡""¸Ì±ÁÙ¦³""
ÁÂÁÂ |
|