µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» ¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e
1
2
¤U¤@¶
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2015-12-8 20:49
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e
»Ýn±NAÄ檺¦r¦ê¨ú¥XÃöÁä¦r«áªº¤º®eºI¦Ü¥t¤@ÃöÁä¦r¤§«e
½Ð°Ýn¥Î¤°»ò¨ç¼Æ?
¥Ø«e·Q±o¨ìn¥ÎFIND§ä¥XÃöÁä¦r LENºâ¥X¦r¤¸ «o¤£·|¼g:'(
¤U¸ü
(10.34 KB)
2015-12-8 20:47
¼Ó¥D¼ö©«
AccessVBA®É¶¡¬d¸ß
¨ú¥X®É¶¡µe®É¶¡¹Ï
¶W³sµ²
¦¬ÂÃ
¤À¨É
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
2
#
µoªí©ó 2015-12-8 20:57
|
¥u¬Ý¸Ó§@ªÌ
Book1.zip
(5.69 KB)
½d¨Ò
¤U¸ü¦¸¼Æ: 11
2015-12-8 20:56
TOP
JBY
µoµu®ø®§
¥[¬°¦n¤Í
JBY
·í«eÂ÷½u
UID
10955
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ª÷¿ú
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
222 ¤p®É
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
¤¤¾Ç¥Í
©«¤l
161
¥DÃD
0
ºëµØ
0
¿n¤À
168
ÂI¦W
0
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
µù¥U®É¶¡
2012-9-16
³Ì«áµn¿ý
2017-2-19
3
#
µoªí©ó 2015-12-9 08:41
|
¥u¬Ý¸Ó§@ªÌ
B2, ¤½¦¡¦V¥k½Æ»s
=-LOOKUP(1,-LEFT(REPLACE($A2,1,FIND("@",SUBSTITUTE($A2,":","@",COLUMNS($A1:A1))),""),ROW($1:15)))
¤U¸ü
(57.3 KB)
2015-12-9 08:42
TOP
ã´£³¡ªL
µoµu®ø®§
¥[¬°¦n¤Í
ã´£³¡ªL
·í«eÂ÷½u
UID
13768
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ª÷¿ú
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
¦b½u®É¶¡
2106 ¤p®É
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
ª©¥D
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
4
#
µoªí©ó 2015-12-9 10:08
|
¥u¬Ý¸Ó§@ªÌ
¨ú¥X¯Â¼Æ¦r. ³Ì¦h15¦ì, µL0¶}ÀY¡G
¢Ð¢±¡G=-LOOKUP(,-MID($A2,FIND(B$1,$A2)+LEN(B$1),ROW($1:$15)))
TOP
hcm19522
µoµu®ø®§
¥[¬°¦n¤Í
hcm19522
·í«eÂ÷½u
UID
22069
©«¤l
1387
¥DÃD
4
ºëµØ
0
¿n¤À
1397
ª÷¿ú
1397
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
1746 ¤p®É
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-11-13
¤j¾Ç¥Í
©«¤l
1387
¥DÃD
4
ºëµØ
0
¿n¤À
1397
ÂI¦W
0
§@·~¨t²Î
WIN
³nÅ骩¥»
2007
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2015-9-11
³Ì«áµn¿ý
2024-11-13
5
#
µoªí©ó 2015-12-9 11:24
|
¥u¬Ý¸Ó§@ªÌ
http://blog.xuite.net/hcm19522/twblog/363756209
TOP
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
6
#
µoªí©ó 2015-12-9 19:47
|
¥u¬Ý¸Ó§@ªÌ
½Ð°Ý¦pªG¦³§¨Âø^¤å¤¤¤å©O??
TOP
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
7
#
µoªí©ó 2015-12-9 21:10
|
¥u¬Ý¸Ó§@ªÌ
¤j¤j̦n
§Ú¥Ø«e·Q¨ì ¥i¬O³Ì«á¤@Ó´N·| ¥X¤£¨Ó¤F@@
=MID($A$2,SEARCH(B1,$A$2,1)+LEN(B1),SEARCH(C1,$A$2,1)-1)
TOP
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
8
#
µoªí©ó 2015-12-9 21:30
|
¥u¬Ý¸Ó§@ªÌ
=MID($A$2,SEARCH(B1,$A$2,1)+LEN(B1),LEN($A$2)-SEARCH(C1,$A$2,1)-LEN(C1))
¼È®É©Ê¥i¥H¤F ¥i¬OÆZ®e©ö¥X¿ùªº~¨D§ó¦n±o¤èªk@@
ÁÙ¦³LOOKUP§Úª¾¹D
-LOOKUP¦hӴ¬O¤°»ò·N«ä??
hcm19522¤j¤jªº..§Ú¬Ý¤£¤ÓÀ´QQ"~¦ü¥G¤£¬O§Ú»Ý¨Dªº?
TOP
ã´£³¡ªL
µoµu®ø®§
¥[¬°¦n¤Í
ã´£³¡ªL
·í«eÂ÷½u
UID
13768
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ª÷¿ú
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
¦b½u®É¶¡
2106 ¤p®É
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
ª©¥D
©«¤l
2833
¥DÃD
10
ºëµØ
0
¿n¤À
2889
ÂI¦W
0
§@·~¨t²Î
¡e²¤¡f
³nÅ骩¥»
¡e²¤¡f
¾\ŪÅv
100
©Ê§O
¨k
¨Ó¦Û
¡e²¤¡f
µù¥U®É¶¡
2013-5-13
³Ì«áµn¿ý
2024-11-12
9
#
µoªí©ó 2015-12-10 13:39
|
¥u¬Ý¸Ó§@ªÌ
=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,C$1,B$1),B$1,REPT(" ",199)),199,199))
TOP
windclover
µoµu®ø®§
¥[¬°¦n¤Í
windclover
·í«eÂ÷½u
UID
20263
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ª÷¿ú
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
20 ¤p®É
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
¤¤¾Ç¥Í
©«¤l
19
¥DÃD
4
ºëµØ
0
¿n¤À
57
ÂI¦W
0
§@·~¨t²Î
windows
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¤k
µù¥U®É¶¡
2015-3-8
³Ì«áµn¿ý
2016-12-27
10
#
µoªí©ó 2015-12-10 21:26
|
¥u¬Ý¸Ó§@ªÌ
ÁÂÁÂ~¦n¦h¨ç¼Æ~n¾Ç¾Ç¥Îªk¤F!
TOP
ÀR«ä¦Û¦b :
¤Hn¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
1
2
¤U¤@¶
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·