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

[µo°Ý] Àx¦s®æ³]­­¦r¤¸¼Æ¶q

[µo°Ý] Àx¦s®æ³]­­¦r¤¸¼Æ¶q

¦U¦ì°ª¤â«e½ú¦n
§Ú±N¥Îµ{¦¡½Æ»s¤F¤@¦æ¸ê®Æ¡A¦ý­ì¸ê®ÆªºÀx¦s®æ¤å¦r«á­±³£¦³ªÅ®æ
§Ú·Q±N½Æ»s«áªºªÅ®æ¨ú®ø¡A½Ð°Ý¦³¤°»ò«ü¥O¥i¥H­­¨îÀx¦s®æªº¦r¼Æ¡A
©Î¬O¥Î§PÂ_±NªÅ®æ¨ú®ø¡C ·PÁ«ü±Ð

ªÅ¥Õ.png (10.96 KB)

ªÅ¥Õ.png

will

¥»©«³Ì«á¥Ñ samwang ©ó 2023-1-12 22:07 ½s¿è

¦^´_ 1# willeddie


¥i¥H¥ÎRTrim
¤Wºô§ä¤@¤U»¡©ú
ÁÂÁÂ

TOP

¦^´_ 1# willeddie


    ÁÂÁ«e½úµoªí¦¹¥DÃD»P±¡¹Ò
1.½Ð¸Õ¸Õ¬Ý¬O§_²Å¦X±¡¹Ò»Ý¨D

Sub ¨ú¥NªÅ¥Õ¦r¤¸¥k°¼()
[D:D].Copy [E1]
[E:E].Replace " *", "", Lookat:=xlPart
End Sub

2.¥Î¿ý»s¥¨¶°:¥HªÅ¦r¤¸¨ú¥N±¼ªÅ¥Õ¦r¤¸¤]¥i¸Õ¸Õ¬Ý
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¦^´_ 1# willeddie
µ¹§A¤@­Ó¤è¦V¡A§Q¥Î¥¨¶°ªþ¥[ªº§Ö±¶Áä¥\¯à¡A¦b¶K¤WÀx¦s®æ¤§«e³B²z¸ê®Æ«á¦A¶K¤W¡A¥ý¸ÕµÛ¼g¬Ý¬Ý¡C( ¥i¨Ï¥Î MID & TRIM ¨ç¼Æ )

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD