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

[µo°Ý] Àx¦s®æ¤º¬Û¦P¦r¦ê³B²z_¨ú¥N

Àx¦s®æ¤º¬Û¦P¦r¦ê³B²z

½Ð°Ý¦U¦ì¤j¤j

¦pªþ¥ó,³o¬O¤@­ººqªººqµü
¤U­±¦r¦ê·|¦bÀx¦s®æ¤º­«½Æ¥X²{
"I've been locked out of heaven"

§Ú·Qª¾¹D
¬O§_¯à±N³o³\¦h¬Û¦Pªº¦r¦ê¤À§O©ñ¨ì°}¦C¤º,¥H«K°µ¦U§O³B²z
¦pªG¥i¦æÀ³¸Ó¦p¦ó°µ??

¬O§_¥i±N·j´M¨ìªº²Ä¤G­Ó¤Î³Ì«á¬Û¦Pªº¦r¦ê´À´«¬° "END",¦Ó¨ä¥L¦r¦ê¤´¬°­ì¥»¦r¦ê??

·s¼WMicrosoft Excel ¤u§@ªí (2).rar (4.73 KB)

½Ð¤j¤j¸Ñ´b~ÁÂÁÂ

TOP

«O¯dªÅ®æ
  1. =MID($A$1,COLUMN(A1),1)
½Æ»s¥N½X
¤£«O¯dªÅ®æ
  1. =MID(SUBSTITUTE($A$1," ",""),COLUMN(A1),1)
½Æ»s¥N½X
¦V°ª¤â学习

TOP

¦^´_ 1# a703130
  1. Sub ex()
  2. mystr = "I've been locked out of heaven"
  3. k = UBound(Split([C5], mystr))
  4. MsgBox "¨ú¥N²Ä2²Õ" & Application.WorksheetFunction.Substitute([C5], mystr, "END", 2)
  5. MsgBox "¨ú¥N²Ä³Ì«á¤@²Õ" & Application.WorksheetFunction.Substitute([C5], mystr, "END", k)
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh


ÁÂÁ¤j¤j
¨S·Q¨ì²³æ´X¦æ¦r«K¯à¸Ñ¨M

TOP

¦^´_ 3# Hsieh

½Ð°Ý¬O§_¯à¥Îreplace ¤è¦¡ª½±µ´À´«?

TOP

[µo°Ý] Àx¦s®æ¤º¬Û¦P¦r¦ê³B²z_¨ú¥N

¦p¤U­±³sµ²

http://forum.twbts.com/thread-9000-1-1.html

§Ú¾Ç¨ìreplaceªº¤èªk

¦ý¬O¤S¹J¨ì¥t¤@­Ó°ÝÃD
¦pªþ¥ó
·s¼WMicrosoft Excel ¤u§@ªí (2).rar (1.76 KB)

§Ú¦pªG­n¨ú¥N¦r¦ê¤¤ªºNever

¦ý§Ú¤]·|¦P®É¨ú¥N Never_1 ...

¤£ª¾¹D¬O§_¦³¤èªk¥u¨ú¥N Never ¦Ó¤£·|³sNever_1 µ¥Ãþ¦ü¦r¦ê¤@°_¨ú¥N

¦^´_ 1# a703130
Never¥[¤W¤@­ÓªÅ¥ÕÁä§@¬°·j´M¥Ø¼Ð
­n¨ú¥Nªº¦r¦ê¤]¥[¤WªÅ¥ÕÁä
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

§Aªº·N«ä¬O

³æ¤@ Never ¦r¦ê³£¦b«á­±¥[¤WªÅ¥Õ¿ëÃѶÜ??

TOP

¦^´_ 3# a703130

ªþ¥ó¤¤ªºNever«á­±¦³¤@­ÓªÅ®æ¡A¥i¥H¸òNever_°µÃѧO
©Ò¥H¥u¦³¦¹¤èªk°µ2ªÌ°Ï§O
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh

ÁÂÁÂH¤j~¥H¤F¸Ñ

Microsoft Excel ¤u§@ªí (2).rar (1.82 KB)
§Ú²{¦b¹J¨ì¥t¤@­Ó°ÝÃD
·í§Ú¸ê®ÆÅܦh®É,§Ú¬O¨Ï¥Îdo loop ¹J¨ì"END" °±¤î³B²z
¦Ó®ÇÃ䪺Àx¦s®æ¬O§Ú¨ú¥NªºÃöÁä¦r
³o³¡¥÷¤]¬O¥Îdo loop ¹J¨ì" " °±¤î³B²z
¨ú¥N«áªºÀx¦s®æ­n¦s¦Ücells(x,9) ,x ©¹¤U¼W¥[
¦ý¬O³Ì«á·|Åܦ¨¥u¨ú¥N1_Never_

´M§äªº¦r¦ê      «Ý¨ú¥Nªº¦r¦ê
Never                             Test
Never_1                     apple
1_Never_                     Gone

¬O§_¦³¿ìªk¸Ñ¨M??

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD