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

gaishutsusuru

¦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­Ì

gaishutsusuru

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


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

­ã´£³¡ªL

¦^´_ 6# gaishutsusuru


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

gaishutsusuru

¦^´_ 4# hcm19522


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

gaishutsusuru

¦^´_ 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

­ã´£³¡ªL

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

hcm19522

https://blog.xuite.net/hcm19522/twblog/589111330

gaishutsusuru

¦^´_ 2# rouber590324


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

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

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

¤U¸ü (30.08 KB)

2020-5-8 14:35

ÃC¦â.zip (6.74 KB)

¤U¸ü¦¸¼Æ: 6

2020-5-8 14:35

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

rouber590324

¦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)