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

[µo°Ý] MID¨ç¼Æ»PVB®æ¦¡µ²ªG¤£¦P¤§°ÝÃD½Ð±Ð

[µo°Ý] MID¨ç¼Æ»PVB®æ¦¡µ²ªG¤£¦P¤§°ÝÃD½Ð±Ð

DEAR ALL¤j¤j
1A1=   -001417Y+002677   
  1.1¨Ï¥Î¨ç¼Æ¨ú=MID(A1,1,7) ¨q¥X -001417
  1.2¨Ï¥ÎVBA¦p¹Ï¤@¨ú¥X ­ÈÅܦ¨ -1417
2.½Ð±Ð¦p¦ó§ïµ½·Ð¤£§[½ç±Ð  THANKS*10000
¹Ï¤@
Sub D­åªRA()
Sheet62.Visible = True
Sheet62.Select
Range("A1").Select
Sheet62.[D1:E65536].ClearContents
X = Sheet62.[C65536].End(xlUp).Row
For M = 1 To X
Sheet62.Cells(M, 4) = Mid(Sheet62.Cells(M, 1), 1, 7)
Next
End Sub
ù

¦^´_ 1# rouber590324


¤èªk¢°¡D¾ãÄæ¥ý³]¦¨¡e¤å¦r®æ¦¡¡f
¤èªk¢±¡G¤å¦r«e¤è¥[¡e³æ¤Þ¸¹¡f±j¨î¥H¡e¤å¦r«¬ºA¡f¶ñ¤J¡A¨Ò¦p¡G[B1] = "'" & Left([A1],7)

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD