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

¥H¤½¦¡¥Î§@Ãþ¦ü¸ê®Æ­åªR¥\¯à

¥H¤½¦¡¥Î§@Ãþ¦ü¸ê®Æ­åªR¥\¯à

Excel¤¤, A1 ¬O±q¨ä¥LExcel³s±µ¦Ó±o¨Óªº e.g.  123 abc 456
ÂI¼Ë¦bB1Åã¥Ü   123
¦bC1 Åã¥Ü  abc
D1 Åã¥Ü 456 ©O¡H

­ø¸Ó®Í¦U¦ì¡I

¦^´_ 2# register313


    THANKS ~ ¡I
Ëݤ§«á¨â®æÀ³¸Ó«Y.....?

TOP

¦^´_ 3# stl

B1=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",99)),COLUMN(A1)*100-99,100))
¦V¥k½Æ»s¨ìD1

TOP

¦^´_ 3# register313


    «YØ{¡I§A¯u¼F®`...
¤@¤j°ï²Å¸¹¡A§Ú·QÃѥΡA¤£¹L¦n¦ü¤ÓÃø³â¡A«¢«¢~
Anyway, thank you very much¡I

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD