½Ð±Ð±N.txtÂন¦Û©w®æ¦¡ªºEXCELÀÉ
- ©«¤l
- 185
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 227
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- ºX舰ª©
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-14
- ³Ì«áµn¿ý
- 2024-10-25
|
½Ð±Ð±N.txtÂন¦Û©w®æ¦¡ªºEXCELÀÉ
n±Nªþ¥óªºTEST.TXTÀɮסAÂনªþ¥óªºTEST.XLSÀÉ®×(¤é´Á¸ò®É¶¡¤À¶}©ñ)¡AÀ³¸Ó«ç¼Ë¼g¡A¦A¤TÁÂÁ¤j¤j!
TEST.rar (3.48 KB)
|
|
|
|
|
|
|
- ©«¤l
- 185
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 227
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- ºX舰ª©
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-14
- ³Ì«áµn¿ý
- 2024-10-25
|
¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-8 02:13 ½s¿è
¦^´_ 2# GBKEE
·PÁª©¤j±Ð±Â¡A¸òª©¤jªº¡A¥X¿ù»~'1004'
¥H¤U¬O³Q¾É¤Jªº¨ä¤¤¤@¦æ¡A¬O©ñ¦bA1®æ¡A¥¼¯à¤À¶}©ñ¤JA1¦ÜG1®æ¡C
20100614 094400; 20084; 20084; 20084; 20084; 571
¤é´Á¤Î®É¶¡®æ¦¡¤]¥¼¯àÂàÅܦ¨¥H¤U¦Û©w®æ¦¡¡C
6/14/2010 09:44:00 20084 20084 20084 20084 571 |
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 3# cdkee
©êºp¤W¦¸¦^´_¤£½TÃD·N§ó¥¿¦p¤U §AªºÀɮצn¹³»PªÑ²¼¦³Ãö?- Sub Ex()
- Dim E As Range
- Workbooks.OpenText Filename:="d:\test\test.txt" ', DataType:=xlDelimited, Tab:=True
- With ActiveWorkbook.Sheets(1)
- For Each E In .Range("A:A").SpecialCells(xlCellTypeConstants)
- With E
- .Value = Mid(E, 5, 2) & "/" & Mid(E, 7, 2) & "/" & Mid(E, 1, 4)
- .NumberFormatLocal = "M/D/YYYY"
- .Offset(, 1) = Mid(.Offset(, 1), 1, 2) & ":" & Mid(.Offset(, 1), 3, 2) & ":" & Mid(.Offset(, 1), 5, 2)
- .Offset(, 1).NumberFormatLocal = "HH:MM:SS"
- End With
- Next
- .Cells.Replace ";", " "
- .SaveAs "d:\test\test.xls" '¦sÀÉ
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 185
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 227
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- ºX舰ª©
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-14
- ³Ì«áµn¿ý
- 2024-10-25
|
¥»©«³Ì«á¥Ñ cdkee ©ó 2010-10-8 08:15 ½s¿è
¦^´_ 4# GBKEE
¦¦wGBKEEª©¤j!¦¨¥\¤F!·PÁ¼ö¤ßªº±Ð¾É!
µ¹ª©¤j»¡¬ï¤F¡A¥¿¬O³á!¦ý¤p½ú¤£¦hª±ªÑ²¼!¥u¬O«O¦u¬£...«¢«¢!
ª©¤j¹ïVBA¬Û·í±M·~¡A¬O±Ð±Â¶Ü?
¥H¤U¬O¤p½ú§@¤F¾ã±ßµL¥ð¡A¤]¥u¬O©U§£¤@°ï!µ¹ª©¤j¨ÓÓ«¢«¢¯º¦À\~
txt to xls.rar (24.67 KB)
|
|
|
|
|
|
|
- ©«¤l
- 185
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 227
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN 7
- ³nÅ骩¥»
- ºX舰ª©
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-9-14
- ³Ì«áµn¿ý
- 2024-10-25
|
¤p½ú¯uªº²Ö·¥...¥ýn¦^¥h¥ð®§!¦A¦¸·PÁÂ!¯¬ª©¤j¦³Ó«¢«¢¯º¦±á! |
|
|
|
|
|
|
- ©«¤l
- 12
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 19
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2010-10-7
- ³Ì«áµn¿ý
- 2011-3-29
|
½Ð°Ý Y¥Lªº ¸ê®Æ®æ¦¡¥H","¬°°Ï¹j¦Ó¤£¬O¥Î"TAB"Áä,¬O§_¤]¥i¥H?ÁÂÁ |
|
SEA
|
|
|
|
|
- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- win7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- new Taipei city
- µù¥U®É¶¡
- 2015-9-5
- ³Ì«áµn¿ý
- 2015-9-5
|
§ä¤F¦n¤[¡Aè¦n¦³»Ýn~ÁöµM¬O©«~¨ÌµM·PÁÂ! |
|
|
|
|
|
|