ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¨ú¯S©w²Å¸¹¥kÃ䪺¦r©Î¼Æ¦r

[µo°Ý] ¦p¦ó¨ú¯S©w²Å¸¹¥kÃ䪺¦r©Î¼Æ¦r

¤wª¾¨ç¼Æ¥i¥H¹F¦¨ B2=RIGHT(A1,LEN(A1)-SEARCH("¯S©w²Å¸¹",A1))

½Ð°Ý«e½ú¡A¦p¦ó¦b¼Ò²Õ§ï¼g¡AÁÂÁ¡C

¦^´_ 1# av8d


    ¸Ñ¶}¤F¡A¥u¦³Seatch»Ý­n¥Î¨ìApplication.WorksheetFunction.Search

¨ç¼ÆLen©MRight¥i¥Hª½±µ¨Ï¥Î¡A¤w¸Ñµª¡C

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

ÁÂÁ«e½ú
«á¾ÇÂǦ¹¥DÃD½m²ß¦p¦ó¤À³Î¦r¦ê¨¾¿ù

Option Explicit
Sub TEST()
Dim T$
[A1] = "12345¯S©w²Å¸¹6789"
T = "¯S©w²Å¸¹"
[B2] = Split([A1] & T, T)(1)
MsgBox [B2]
[C2] = Split([B2] & T, T)(1)
MsgBox [C2]
[C2] = Split([B2], T)(1)
MsgBox [C2]
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 4# Andy2483


    ¦^´_¦Û¤vªº²Ê¤ß¤j·N
±¡¹Ò»Ý¨D¦³¦hºØ,¥t·Q¨ì¤£¦P±¡¹Ò»Ý¨D

Option Explicit
Sub TEST_2()
Dim T$
[A1] = "12345¯S©w²Å¸¹6789¯S©w²Å¸¹ABCDE"
T = "¯S©w²Å¸¹"
[B2] = [A1]
[B2].Replace "*" & T, "", 2
MsgBox [B2]
End Sub

Sub TEST_3()
Dim T$
[A1] = "12345¯S©w²Å¸¹6789¯S©w²Å¸¹ABCDE"
T = "¯S©w²Å¸¹"
[B2] = Mid([A1], InStr([A1], T) + Len(T))
MsgBox [B2]
End Sub
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD