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

[µo°Ý] ²M°£¬Ý¤£¨£ªºªÅ®æ

[µo°Ý] ²M°£¬Ý¤£¨£ªºªÅ®æ

±q¨t²Î¤U¸üÀɮסA
¨ä¤¤¦³´X­ÓÀx¦s®æ¬Ý¦ü¦³ªÅ®æ¡A
    For Each Rng In Selection
    Rng.Value = Application.WorksheetFunction.Clean(Trim(Rng.Value))
    Next Rng
¥ý¥Hclean¦A¥Îtrim¨Ó°µ§R°£ªÅ®æªº¾ã²z¡A
¦ý¾ã²z«á¤´µL°µ¶}ÀY¥H1¿z¿ïªº³B²z¡A
¯à§_½Ð¬Ý¬Ý¬O¤°»òª¬ªp©O¡H
Àx¦s®æ°ÝÃD.rar (6.14 KB)

¦pªG¥Î[Ctrl]+[F] ·j´M"ªÅ®æ"«á¨ú¥N©O?

TOP

½T¹ê¬O¥i¥H¿z¿ï¤F¡A¦ý¨Ï¥Îvlookupªº¸Ü¡A«o¦ê¤£¨ì¸ê®Æ¡A½Ð°Ý¬O¦ó¸Ñ¡H

TOP

¡@For Each Rng In Selection
¡@¡@¡@Rng = Trim(Application.Clean(Rng))
¡@Next

¥ýClean¡A¦A¥hªÅ¥Õ¡ã¡ã

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD