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

[µo°Ý] ¦p¦ó¨úªºªÅ¥Õ«á­±ªº¦r¦ê

[µo°Ý] ¦p¦ó¨úªºªÅ¥Õ«á­±ªº¦r¦ê

¥»©«³Ì«á¥Ñ jsc0518 ©ó 2020-12-29 21:29 ½s¿è

Dear all,
§Ú¦³¤@¦ê¨t²Î¼´¤U¨Óªº¸ê®Æ¡A¦ý¨C¤@­Ó¸ê®Æ«á­±³£¬O¤@­ÓªÅ¥Õ(°£³Ì«á¤@µ§¸ê®Æ«á­±¨SªÅ¥Õ)¡A§Ú­n¨Ï¥Î­þ¤@¤½¦¡¥h©î¤À¦¨¤£¦PªºÀx¦s®æ©O¡H
¹Ï¤ù¦p¤U
Noname.jpg
2020-12-29 21:29

¤½¦¡©î¤À.rar (7.87 KB)
Just do it.

DIM varArrstr as Varriant
DIM coli as Integer

varArrStr = Split(InputString, " ")  


For coli =0 to 10 step 1

if varArrStr(coli ) ="" then
   exit for
end if

cells(1,coli +1) =varArrStr(coli )

Next coli
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522

Hi ±z¦n¡I·PÁ¦^´_¡C
½Ð°Ý¥i¥H±Ð§Ú¤@¤U¤½¦¡»¡©ú¶Ü¡H
=TRIM(MID(SUBSTITUTE(TRIM(B$2)," ",REPT(" ",99)),ROW(A1)*99-98,99))
³o§Ú¤£¬O«ÜÀ´
·P®¦¡I
Just do it.

TOP

¦^´_ 2# ¼B¤j­G

Hi Sir,
³o»yªk¬O¬Æ»ò·N«ä°Ú¡H
·PÁ±z
Just do it.

TOP

(¤@)TRIM§RÀY§ÀªÅ¥Õ ¦r»P¦r¶¡¥u¯d¤@
(¤G)¤@ªÅ¥ÕÂX¤j99  ±q²Ä¤@¦r¤¸ ¨ú99ªø«× ¦ATRIM¬°²Ä¤@¦r²Å¦ê
(¤T)±q²Ä100 (1+99)¦r¤¸ ¨ú99ªø«× ¦ATRIM¬°²Ä¤G¦r²Å¦ê
¥H¦¹Ãþ±À
ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

¦^´_ 3# hcm19522
Hi Sir,
¦­¦w¡A±z¦n¡I
§Ú§âµe­±Åܦ¨¤U­±¹Ï¥Ü¡A§â¦U¸ê®Æ¥H"/"¤è¦¡°µ¬°°Ï¹j¡C
¹³³o¼Ëªº¸Ü¡A¤½¦¡­n«ç»ò¥h¼g¡H
§Ú·Q¥Î¤½¦¡¼g¦¨¸ò¥kÃä¤@¼Ë¡A¦]¬°§Ú¬O¥ÎBar Codeªº¤è¦¡¥h±½¥X¸ê°Tªº¡A·Q¥Î¤½¦¡¦Û°Ê©î¤À¥X¸ê°T
ÁٽФj®aÀ°¦£¡I¡I
Noname.jpg
2021-1-4 09:04


¤½¦¡©î¤À2.rar (7.59 KB)
Just do it.

TOP

=TRIM(MID(SUBSTITUTE(TRIM($A2),"/",REPT(" ",99)),COLUMN(A1)*99-98,99))
ÀH·NºÛ "EXCEL°g"  blog  ©Î http://blog.xuite.net/hcm19522/twblog[img][/img]
¤w¦¬¶°7000½g EXCEL¨ç¼Æ

TOP

¦^´_ 8# hcm19522


Hi hcm19522,,
¤Ó·PÁ§AªºÀ°¦£¤F¡A¸Ñ¨M§Úªº°ÝÃD¡I¡I
Just do it.

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD