- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 245
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-12
|
¦^´_ 1# jj369963
¦³¨S¦³§Ö³t¤èªk?ˬOÁÙ¨S·Q¥X¨Ó
¥Î¤½¦¡ÁÙ¦³ÂI½ÆÂø
1¡B¿ï¨úB1Àx¦s®æ
2¡B«Ø¥ß4Ó¦WºÙ
k=(COLUMN(Sheet1!A$1)-1)*2+1
x=(LEN(Sheet1!$A1)-LEN(SUBSTITUTE(Sheet1!$A1,"'","")))/2
y=MID(Sheet1!$A1,SMALL(ar,k)+1,SMALL(ar,k+1)-SMALL(ar,k)-1)
ar=SMALL(IF(MID(Sheet1!$A1,ROW(INDIRECT("A1:A"&LEN(Sheet1!$A1))),1)="'",ROW(INDIRECT("A1:A"&LEN(Sheet1!$A1))),""),ROW(INDIRECT("A1:A"&x*2)))
3¡BB1¤½¦¡="('"&y&"'="&y&") "
¦V¤U¦V¥k½Æ»s¨ìJ4
4¡BK1¤½¦¡=B1&C1&D1&E1&F1&G1&H1&I1&J1
¦V¤U½Æ»s
|
|