½Ð±Ð:¤@Ä椺¦³¦hµ§¸ê®Æ,¦p¦ó´£¨ú¯S©wȪº¸ê®Æ
- ©«¤l
- 14
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 19
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-9-5
- ³Ì«áµn¿ý
- 2015-7-22
|
½Ð±Ð:¤@Ä椺¦³¦hµ§¸ê®Æ,¦p¦ó´£¨ú¯S©wȪº¸ê®Æ
¦U¦ì¥ý¶i,¦³¤U¦Cªº°ÝÃD,¤£ª¾¯à¤£¯à¨ó§U¸Ñ¨M!!
¦p¹Ï:·Q°w¹ï"¤p§õ"³oÓ¯S©wÈ°µ¬°¯S©wÈ,±N¤p§õªº¯S©wÈ´£¥X,©ñ¸m¦b®Ç....
|
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# b31978
¥i¸Ô¬Ý VBA »¡©ú
Filter ¨ç¼Æ ¶Ç¦^¤@Ó±q¹s¶}©lªº°}¦C¡A¸Ó°}¦C¥]§t°ò©ó«ü©w¿z¿ï·Ç«hªº¤@Ó¦r¦ê°}¦Cªº¤l¶°¡C
Split ¨ç¼Æ ¶Ç¦^¤@Ó³¯¦C¯Á¤Þ±q¹s¶}©lªº¤@ºû°}¦C¡A¥¦¥]§t«ü©w¼Æ¥Øªº¤l¦r¦ê¡C
Replace ¨ç¼Æ ¶Ç¦^¤@Ó¦r¦ê¡A¸Ó¦r¦ê¤¤«ü©wªº¤l¦r¦ê¤w³Q¨ú¥N¦¨¥t¤@¤l¦r¦ê¡A¨Ã¥B¨ú¥Nµo¥Íªº¦¸¼Æ¤]¬O«ü©wªº¡C- Option Explicit
- Sub Ex()
- Dim E As Range, A As Variant, i As Integer, B As String
- For Each E In [AL12:AL26] '½d³ò¤¤ªº¨C¤@Ó¦¨û(E)
- i = 0
- For Each A In Filter(Split(E, vbLf), "¤p§õ:", True)
- 'Miscellaneous ±`¼Æ vbLf -> Chr(10) : ´«¦æ¦r¤¸¡C
- B = Replace(A, "¤p§õ:", "")
- B = Replace(B, "PCS", "")
- i = i + B
- Next
- E.Offset(, 1) = IIf(i <> 0, i, "") '¥kÃä²Ä 1 Äæ
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 14
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 19
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-9-5
- ³Ì«áµn¿ý
- 2015-7-22
|
ÁÂÁÂ,§ì¯}¸£§ï¤F¦n¦h¤Ñ,ÁÙ¬O¤j¯«¼F®`....ÁÂÁ |
|
|
|
|
|
|