- ©«¤l
- 79
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 193
- ÂI¦W
- 0
- §@·~¨t²Î
- Winwos 7 64 bits
- ³nÅ骩¥»
- Excel 2003/2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIPEI
- µù¥U®É¶¡
- 2010-8-25
- ³Ì«áµn¿ý
- 2019-9-20
|
¥»©«³Ì«á¥Ñ diabo ©ó 2011-6-26 01:12 ½s¿è
- Sub ¸ê®ÆåªR()
- '¨ú±o¸ê®Æ³Ì«á¤@¦C
- last_row = Sheet1.[AO65536].End(xlUp).Row
- '¨ú±o¶ñ¤J©m¦W¤§Äæ¼Æ
- col_bgn = Sheet1.Range("BJ1").Column
-
- For r = 2 To last_row
- '±ý¸ÑªR¤§ì©l¸ê®Æ¤º®e
- raw_data = Sheet1.Range("AO" & r).Value
- '¥H#¤À³Î¦r¦ê¬°°}¦C(Array)
- arr_Name = Split(raw_data, "#")
- For n = 1 To UBound(arr_Name)
- '²ÄnÓ©m¦W¦^¶ñ¸ê®ÆÄæ¼Æ
- c = col_bgn + n
- '¨ú¥X¾ºÙ+©m¦W+....
- raw_name = Trim(arr_Name(n))
- '¨úªº$¦ì¸m
- pos = InStr(1, raw_name, "$")
- '¨ú¥X©m¦W--°²³]¾ºÙ¬Ò¬°¨âÓ¦r(½Ð¦Û¦æ±NAD2ªº¡u±µ±a«Ý¡v§ï¬°¡u±µ«Ý¡v)
- Sheet1.Cells(r, c).Value = Mid(raw_name, 3, IIf(pos = 0, 255, pos - 3))
- Next
- Next
- End Sub
½Æ»s¥N½X |
|