- ©«¤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
|
¦^´_ 2# kuhsuanchieh
¸Õ¸Õ¬Ý- Option Explicit
- Sub Ex()
- Dim Rng As Range, A As Variant, Ar(), e As Variant, Ay(), i As Integer, x_Er As String
- Ar = Array("¥«", "¿¤", "°Ï", "¶m", "Âí") '¦æ¬F°Ï
- Set Rng = Sheets("¤u§@ªí1").[A2]
- Do While Rng <> ""
- i = i + 1
- A = Rng.Text
- A = Replace(A, "F", "¼Ó")
- A = Replace(A, "f", "¼Ó")
- For Each e In Ar
- A = Replace(A, e, e & ",")
- Next
- A = Split(A, ",")
- ReDim Preserve Ay(1 To i)
- If UBound(A) = 2 Then
- For Each e In Array("§ø", "¨½", "¾F", "?") '¾F ¦Õ¦³¥ª,¦³¥k
- A(2) = Replace(A(2), e, e & ",")
- Next
- If InStr(A(2), ",") Then
- A(2) = Split(A(2), ",")(UBound(Split(A(2), ",")))
- End If
- A(2) = Ex_°ê¦rÂà¼Æ¦r(A(2) & "")
- '°ê¦rÂà¼Æ¦r¥i¦Û¤vGOOGLE½m²ß¤@¤U
- Ay(i) = A
- Else
- Ay(i) = Array("", "", "")
- x_Er = x_Er & "," & Rng.Address(0, 0)
- End If
- Set Rng = Rng.Offset(1)
- Loop
- Rng.Parent.[b2].Resize(i, 3) = Application.Transpose(Application.Transpose(Ay)) '
- If x_Er <> "" Then MsgBox Mid(x_Er, 2), Title:="¦í§}»Ý¥Î¤â¤u×¥¿"
- End Sub
- Function Ex_°ê¦rÂà¼Æ¦r(x_Word As String) As String
- Ex_°ê¦rÂà¼Æ¦r = x_Word
- End Function
½Æ»s¥N½X |
|