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

[µo°Ý] «ö¦r¤¸¼Æ¶q¿z¿ï¹q¶l¦a§}

[µo°Ý] «ö¦r¤¸¼Æ¶q¿z¿ï¹q¶l¦a§}

§Ú¤½¥q¸gÀçÁʪ«ºô¯¸ªº, ¦­´Áªº®É­Ô¦]¬°­n§l¤Þ§ó¦h¤Hµù¥U©Ò¥HÃö±¼µù¥UÅçÃÒ¹q¶lªº³¡ÆJ.
©Ò¥H´N¥X²{«Ü¦h©_©Ç©M¨S®Äªº¹q¤l¶l¥ó,Ä´¦p"[email protected]"©Î"[email protected]"
¤w¸g¥Î¹L«Ü¦hÅçÃÒ¹q¶lªº³n¥ó¥h³B²z¦ýÁÙ¬O¬y¤U¤@°ï¨S®Äªº¹q¶l,
²{¦b§Ú»Ý­n´À¤½¥q§â¦r¤¸¼Æ¤Ö©ó12¦ìªº¹q¶l§ä¥X¨Ó¨Ã§R±¼¥H§K®ö¶O¤½¥q¸ê·½,
½Ð°Ý¦bexcel¤¤¦³¨S¦³¤°»ò¤èªk¥i¥H³B²z³o­Ó´Æ¤âªº°ÝÃD? ÁÂÁ¤j®a

½Ð°Ý¬O­n±qmail²M³æ¤¤¼Ð¥Ü¥XµL®Äªºmail¤è«K±z°µ§R°£¶Ü?
Maggie

TOP

¦^´_ 1# jcmdrt


    12¦ì¤¸ ¬O«ü  @  «e­±ªº¦ì¤¸¼Æ ÁÙ¬O Á`¦ì¤¸¼Æ??
[email protected]  ?
1234567891234 ?

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¥H¤U¬O¤@ÂIÂIªº¤pµ{¦¡
¥i¥H¥ý©ñ¤@¨Ç¸ÕÅç¬Ý¬Ý
¦A¥Î¿z¿ï¥\¯à¿z¿ï
  1. Private Sub CommandButton1_Click()
  2. '«e¸m
  3.     [a1] = "¹q¤l«H½c"
  4.     [b1] = "Á`¦r¼Æ"
  5.     [c1] = " @©Ò¦b¦ì¸m"
  6.     [d1] = " @«e¦r¼Æ"
  7.     [e1] = " @«á¦r¼Æ"
  8.    
  9. 'Äæ¼e
  10.     Columns("a:a").Select
  11.     Selection.ColumnWidth = 35
  12.     Columns("B:B").Select
  13.     Selection.ColumnWidth = 10
  14.     Columns("C:C").Select
  15.     Selection.ColumnWidth = 15
  16.     Columns("D:D").Select
  17.     Selection.ColumnWidth = 10
  18.     Columns("E:E").Select
  19.     Selection.ColumnWidth = 10
  20.    
  21. 'µ{¦¡°Ï
  22.     For pg = 2 To ActiveSheet.Range("a1").CurrentRegion.Rows.Count
  23.         Cells(pg, 2) = Len(Cells(pg, 1))
  24.         Cells(pg, 3) = InStr(Cells(pg, 1), "@")
  25.         Cells(pg, 4) = Mid(Cells(pg, 1), 1, Cells(pg, 3) - 1)
  26.         Cells(pg, 5) = Mid(Cells(pg, 1), Cells(pg, 3) + 1, 90)
  27.    
  28.     Next
  29. End Sub
½Æ»s¥N½X

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

½Ð°Ý¬O­n±qmail²M³æ¤¤¼Ð¥Ü¥XµL®Äªºmail¤è«K±z°µ§R°£¶Ü?
amaggie_h µoªí©ó 2012-10-18 10:06


¹ï§r, ¦]¬°¦³¨Ç¹q¶l¬O [email protected].

TOP

¦^´_  jcmdrt


    12¦ì¤¸ ¬O«ü  @  «e­±ªº¦ì¤¸¼Æ ÁÙ¬O Á`¦ì¤¸¼Æ??
  ?
1234567891234 ?
mark15jill µoªí©ó 2012-10-18 10:14


Á`ªº¦ì¼Æ12¥H¤U, ¦ý¤]·|°µ½Õ¾ãªº, ¥ý§ä8¦ìªº, ¦A§ä9¦ìªº¶¶§Ç§ä¤U¥h, ºÉ¥i¯à§âµL®Äªº¥h±¼´î»´¦øªA¾¹ªºÀ£¤O.

TOP

¥H¤U¬O¤@ÂIÂIªº¤pµ{¦¡
¥i¥H¥ý©ñ¤@¨Ç¸ÕÅç¬Ý¬Ý
¦A¥Î¿z¿ï¥\¯à¿z¿ï
mark15jill µoªí©ó 2012-10-18 10:29


ÁÂÁ±zªºµ{¦¡, ¦ý¤£ª¾¹D«ç¼Ë¥Î©O, §Ú¥hª¦ª¦¤å¬Ý¬Ý, ¦pªG§A¤è«Kªº¸Ü¤]§i¶D§Ú«ç¼Ë¥Î ÁÂÁÂ~

TOP

¦^´_ 7# jcmdrt

³o­Ó¬O±N­n¤À¸Ñªº ¹q¤l«H½c ©ñ¦bAÄæ¦ì..
°õ¦æ«á  ·|¤À¸Ñ¶}¨Ó
¥i¨Ì·Ó Á`¦r¼Æ¬O§_¶W¹L12 ¦A¥h°µ¿z¿ï(excel ¤º¦³¹w³]¥\¯à)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD