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

[µo°Ý] ½Ð°Ý¦p¦ó´£¨úÀx¦s®æªº¸ê®Æ©O¡H

[µo°Ý] ½Ð°Ý¦p¦ó´£¨úÀx¦s®æªº¸ê®Æ©O¡H

¥»©«³Ì«á¥Ñ gaishutsusuru ©ó 2020-5-8 13:24 ½s¿è

¦U¦ì¤j¤j¦n¡A

·Q½Ð°Ý§Ú¦³¤@­ÓÀx¦s®æ¡uSS(¬õ),S(¾í),M(¶À),L(ºñ),XL(ÂÅ),XXL(µµ)¡v

­n¦b¥t¥~6­ÓÀx¦s®æ¤À§O¨ú¥X³o6­Ó¤Ø¤oªºÃC¦â ¡A¤½¦¡¸Ó¦p¦ó¤U©O¡H


¡]§Ú¸ÕµÛ¥Îfind§ä¡§SS(¡§ ©M¡§S(¡§¡Aµ²ªGÅã¥Üªº¦ì¸m¬O1©M2¡C³o¼Ë¬Ý°_¨Ó¤£¯à¤À§O§ä¥XSS©MS¡C¡^


¦A½Ð¤j®a¨ó§U¡AÁÂÁ±z­Ì

¦p¤U
=MID(A1,SEARCH("(",A1)+1,1)
=MID(A1,SEARCH("(",A1,SEARCH("(",A1)+1)+1,1)
=MID(A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1)+1)+1)+1,1)
=MID(A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1)+1)+1)+1)+1,1)
=MID(A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1)+1)+1)+1)+1)+1,1)
=MID(A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1,SEARCH("(",A1)+1)+1)+1)+1)+1)+1,1)
ù

TOP

¦^´_ 2# rouber590324


±z¦n¡AÁÂÁ±zªº¦^ÂСA

¦ý¹ê´ú«á¦pªG¥u¦³³¡¥÷¤Ø¤o¦Ó¤w¡A³o¼Ë¤½¦¡·|¤£¯à§ä¥X¥¿½Tªº­È¡C

¦]¦¹ªþ¤W§Æ±æ§e²{ªº¹Ï¤ù©MÀÉ®×µ¹±z°Ñ¦Ò¡C

Â^¨ú.PNG
2020-5-8 14:35



ÃC¦â.zip (6.74 KB)


¦A½Ð¦U¦ìÀ°¦£¨ó§U¡AÁÂÁ¡C

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=MID($A2,FIND("¡A"&B$1&"(","¡A"&$A2&"¡A"&B$1&"(")+LEN(B$1)+1,1)

TOP

¦^´_ 5# ­ã´£³¡ªL

­ã´£¤j¤j±z¦n¡AÁÂÁ±z´£¨Ñ·Qªk¡C

¤£¦n·N«ä¡A·Q¦A½Ð±Ð¦pªG¸Ì­±ªºÃC¦â¬O¤@­Ó¦r¥H¤Wªº¸Ó¦p¦ó³B²z©O¡H
¹³¬OSS(¯»¬õ)

¦A½Ð±z¨ó§U¡AÁÂÁ¡C

TOP

¦^´_ 4# hcm19522


ÁÂÁÂhcm¤j¤jªº¨ó§U¡A¤½¦¡¥i¥H¦¨¥\¨Ï¥Î

TOP

¦^´_ 6# gaishutsusuru


=TRIM(LEFT(SUBSTITUTE(MID($A2,FIND("¡A"&B$1&"(","¡A"&$A2&"¡A"&B$1&"(")+LEN(B$1)+1,9),")","   "),3))

TOP

¦^´_ 8# ­ã´£³¡ªL


  ÁÂÁ­㴣¤j¤j´£¨Ñªº¨ó§U:D

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD