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

[µo°Ý] ¦³Ãö ªÅ®æ¤Î ' ªº¤@­Ó©Ç°ÝÃD

[µo°Ý] ¦³Ãö ªÅ®æ¤Î ' ªº¤@­Ó©Ç°ÝÃD


¦p¤W¹Ï A3 ¬O§Ú¤£·Q­nÅã¥Üªº¦] ¥L·|¦h¤@­ÓªÅ®æ ¾É­P¨Ï¥Îmatch ®É§ä¤£¨ìrange("|I5")ªº­È

¥ÎA5®É´N¯à¶¶§Q§ä¨ì

µM«á§Ú¦bVBA¤¤¥ÎTRIM ()¥LÓý·|Åܦ¨¤U¹Ï ¤@¼Ë§ä¤£¨ì,
Åã¥Ü¦bA6ªº '¤£¨£¤F¦ý¹ê»Ú¤WÁÙ¦b


¦ý¬O§Ú§ï¦bEXCEL¤¤¥Îtrim(A1),¦p¤U¹ÏÓý¤SÅã¥Ü¦¨§Ú·Q­nªº,¤]¯à¶¶§Q¦bI5¤¤§ä¨ì



·Q°Ýªº¬O­n«ç°µ¤~¯à¦bVBA¤¤¨Ï¥Î¤Ftrim(X)¤§«á ·|Åã¥Ü¥¿±`©Î¦³¤°»ò¨ä¥¦°µªk©O??


Book1.rar (7.17 KB)

try ¡i"'" &TRIM(A1)¡j
ss

TOP

¥»©«³Ì«á¥Ñ icestormer ©ó 2014-3-3 19:50 ½s¿è

¦^´_ 2# sunnyso


    ¸Õ¹L¤£¦æ ¤£ºÞ«ç¸Õ ¥L´N·|¦hªÅ­Ó¥b­ÓªÅ¥Õ®æ

¦³ªk¤l ¥[¤@­Ó¥b­ÓªÅ¥Õ®æ¤W¥h??

;­è§Ë¥X¨Ó¤F §Ú¥ý¦b«eÀY§Ë¤@­Ó " '''" (¥[¤T­Ó')

²Õ°_¨Ó«á¦A¥ÎRIGHT ¦©°£¤£­nªº©T©wªø«× ´N¥¿±`¤F...

Á`¤§ ·P¿Î§Aªº¦^À³

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD