- ©«¤l
- 234
- ¥DÃD
- 19
- ºëµØ
- 0
- ¿n¤À
- 276
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows XP
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-1-7
- ³Ì«áµn¿ý
- 2021-10-7
|
¦^´_ 2# adrian_9832
¥i¥H¥ÎSplit«ü¥O
Sub ex()
Dim x
x = Split(Sheets(1).Range("a1"), "/") 'PN/NN NUMBERING:24312(0-1)XX/4100602(0-1)XX¿é¤J¦bRange("a1")·í¥Ü½d,§Q¥Î¦r¦ê¤ºªº"/"±N¦r¦ê©î¶}
x = Split(x(2), "XX") '§Q¥Î"XX"±N4100602(0-1)¨ú¥X
MsgBox x(0)
End Sub |
|