Excel 2007º¯Êý¹«Ê½ÊµÀý»ã×Ü ÏÂÔØ±¾ÎÄ

Åжϵ¥Ôª¸ñÊ××Ö·ûÊÇ·ñΪ×Öĸ:

=OR(AND(CODE(A2)>64,CODE(A2)<91),AND(CODE(A2)>96,CODE(A2)<123))

¼Æ Ëãµ¥Ôª¸ñÖÐÊý×Ö¸öÊý:{=SUM((CODE(MID(A2,ROW(INDIRECT(\(CODE(MID(A2,ROW(INDIRECT(\

¼ÆËãµ¥Ôª¸ñÖдóд ¼ÓСд×Öĸ¸öÊý:{=SUM((CODE(UPPER(MID(A2,ROW(INDIRECT(\gt;64)*(CODE(UPPER(MID(A2,ROW(INDIRECT(\

²úÉú´ó¡¢Ð¡Ð´×ÖĸAµ½ZµÄÐòÁÐ:´óд×Öĸ=CHAR(ROW(A65))£¬Ð¡Ð´×Öĸ=CHAR(ROW(A65)+32) ²ú Éú´óд×ÖĸAµ½ZZµÄ×ÖĸÐòÁÐ:=IF(ROW()<27,CHAR(MOD(ROW()-1,26)+65),CHAR(65+ (ROW()-1)/26-1))&IF(ROW()>26,CHAR(MOD(ROW()-1,26)+65),\ ²úÉúÈý¸ö×Öĸ×é³ÉµÄËæ»ú×Ö·û´®:

=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90)) Óù«Ê½²úÉú»»Ðзû:=A2&CHAR(10)&B2

½«Êý×Öת»»³ÉÓ¢ÎÄ×Ö·û:×Ö·ûÂë=RANDBETWEEN(1,100)£¬ÉýÐòλÅZ=CHAR(MOD(A1-1,26)+65) ½«×ÖĸÉýÐòÅÅÐò:{=CHAR(SMALL(CODE(A$2:A$13),ROW(A1)))}

·µ»Ø×Ô¶¯»»Ðе¥Ôª¸ñµÄµÚ¶þÐÐÊý¾Ý:=RIGHT(A2,LEN(A2)-FIND(CHAR(10),A2)) ¸ù¾ÝÉí·ÝÖ¤ºÅÂëÌáÈ¡³öÉúÄêÔÂÈÕ:=CONCATENATE(MID(B2,7,4-2*(LEN(B2)=15)),\Äê \ÔÂ\ÈÕ \

¼ÆËãÆ½¾ù³É¼¨¼°ÆÀÅÐÊÇ·ñ¼°¸ñ:=CONCATENATE(INT(AVERAGE(B2:D2)),\\²»\¼°¸ñ\ Ìá ȡǰÈýÃûÈËÔ±ÐÕ

Ãû:=CONCATENATE(LOOKUP(0,0/(B2:B11=LARGE(B2:B11,1)),A2:A11),\E(B2:B11,2)),A2:A11),\ ½«µ¥´Êת»»³ÉÊ××Öĸ´óд:=PROPER(A2) ½«ËùÓе¥´Êת»»³ÉСдÐÎʽ:=LOWER(A2)

½«ËùÓоä×Óת»»³ÉÊ××Öĸ´óдÆäÓàСд:

=CONCATENATE(PROPER(LEFT(A2)),LOWER(RIGHT(A2,LEN(A2)-1))) ½«ËùÓÐ×Öĸת»»³É´óдÐÎʽ:=UPPER(A2)

¼Æ Ëã×Ö·û´®ÖÐÓ¢ÎÄ×Öĸ¸öÊý:{=SUM(N(NOT(EXACT(UPPER(MID(A2,ROW(INDIRECT(\ LEN(A2))),1)),LOWER(MID(A2,ROW(INDIRECT(\

¼Æ Ëã×Ö·û´®Öе¥´Ê¸öÊý:{=SUM(N(EXACT(TRIM(MID(UPPER(A2),ROW(INDIRECT(\ LEN(A2))),1)),MID(PROPER(A2),ROW(INDIRECT(\ ½«Îı¾ÐÍÊý×Öת»»³ÉÊýÖµ:{=SUM(VALUE(B2:B10))}

¼ÆËã×Ö·û´®ÖеÄÊý×Ö¸öÊý:=SUMPRODUCT(N(ISNUMBER(VALUE(MID(A2,ROW($1:$100),1)*1)))) ÌáÈ¡»ìºÏ×Ö·û´®ÖеÄÊý×Ö:

{=MAX(IFERROR(VALUE(MID(A2,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A2&1234567890)),ROW(INDIRECT(\&LEN(A2))))),0))}

´®ÁªÇøÓòÖеÄÎı¾:=CONCATENATE(T(A2),T(B2),T(C2))

¸ø¹«Ê½Ìí¼ÓÔËËã˵Ã÷:=CONCATENATE(\ÄãºÃ\¹«Ê½º¬Òå:Á¬½Ó¡°ÄãºÃ¡±ºÍµ¥Ôª¸ñB2¡¢¡°2008¡±\

¸ù¾ÝÉí·ÝÖ¤ºÅÂëÅжÏÐÔ±ð:=TEXT(MOD(MID(B2,15,3),2),\ÄÐ;[=0]Å®\ ½«ËùÓÐÊý¾Ýת»»³É±£ÁôÁ½Î»Ð¡ÊýÔÙÇóºÍ:{=SUM(--TEXT(B2:B11*C2:C11,\ ½«»õ¿îÏÔʾΪ¡°ÍòÔª¡±Îªµ¥Î»:=TEXT(B2,\£¤#\ÍòÔª\

¸ù¾ÝÉí·ÝÖ¤ºÅÂë¼ÆËã³öÉúÈÕÆÚ:=IF(LEN(B2)=15,19,\Äê00ÔÂ00ÈÕ\ ÏÔʾ½ñÌìµÄÓ¢ÎÄÈÕÆÚ¼°ÐÇÆÚ:=\×ÊÁÏÈÕÆÚ£º\ ÏÔʾ½ñÌìÿÏ³ÌµÄÔ¤¼ÆÍê³Éʱ¼ä:=TEXT(SUM(\ÉÏÎç/ÏÂÎç\ ͳ¼ÆAÁÐÓжàÉÙ¸öÐÇÆÚÈÕ:{=SUM(N(TEXT(A1:A11,\ÈÕ\

½«Êý¾ÝÖØ¸´ÏÔʾ5´Î:=SUBSTITUTE(TEXT(A2&\£¿\£¿\½«±íʾÆðֹʱ¼äµÄÊý×Ö¸ñʽ»¯ÎªÊ±¼ä¸ñʽ:=TEXT(B2,\¸ù ¾ÝÆðֹʱ¼ä¼ÆËã¾­¹ýʱ ¼ä:=TEXT(INT(((TEXT(RIGHT(B4,4),\

(LEN(B4)=8)),\

(LEN(B4)=8)),\Сʱ.00·ÖÖÓ\ ½«Êý×Öת»¯³Éµç»°¸ñʽ:=TEXT(A2,\

ÔÚA1:A7ÇøÓò²úÉúÐÇÆÚÒ»µ½ÐÇÆÚÈÕµÄÓ¢ÎÄÈ«³Æ:{=TEXT(ROW(1:7)+1,\

½«»ã×ܽð¶î±£ÁôһλСÊý²¢ÏÔʾǧ·Öλ·Ö¸ô·û:{=FIXED(SUM(--FIXED(B2:B11*C2:C11,1)),1,FALSE)} ¼ÆËã¶©µ¥½ð¶î²¢ÒÔ¡°°ÙÍò¡±Îªµ¥Î»ÏÔʾ:=FIXED(SUMPRODUCT(B2:B10,C2:C10),-6)/1000000 ½«Êý¾Ý¶ÔÆëÏÔʾ£¬½«¿Õ°×ÒÔ¡°£®¡±Õ¼Î»:=WIDECHAR(REPT(\

Àû Óù«Ê½ÖÆ×÷¼òÒ×ͼ±í:=IF(B2>0,REPT(\\£ü\¡ö\amp;REPT(\\¡ö\£ü\

Àû Óù«Ê½ÖÆ×÷´øÖáµÄͼ±íÇÒ±êʾÉý½µ:{=IF(A2<>\©Ï\¡þ\(MAX(ABS(B$2:B$8))+6)*2),IF(B2>0,REPT(\ \ \¡ú\¡ü\¡ý\ REPT(\

¡ö

\

\

\¡ö\

\¡ú\¡ü\¡ý\ ¼ÆËãµ¥Ôª¸ñÖÐÊý×Ö¸öÊý:=LEN(A2)*2-LENB(A2) ½«Êý×Öµ¹ÐòÅÅÁÐ:

{=TEXT(SUM(MID(A2,ROW(INDIRECT(\LEN(A2)))}

¼ÆË㹺Îï½ð¶îÖÐСÊýλÊý×î¶àÊǼ¸:{=MAX(LEN(B2:B10*C2:C10)-LEN(INT(B2:B10*C2:C10)))-1} ¼ÆËãÓ¢Îľä×ÓÖÐÓм¸¸öµ¥´Ê:=LEN(A2)-LEN(SUBSTITUTE(SUBSTITUTE(A2,\ ½«Ó¢Îľä×ӹ淶»¯:=PROPER(LEFT(A2))&TRIM(RIGHT(A2,LEN(A2)-1))

·Ö±ðÌáȡʡÊÐÏØÃû:=TRIM(MID(SUBSTITUTE($A2,\ ÌáȡӢÎÄÃû×Ö:=LEFT(A2,FIND(\

½«·ÖÊýת»»³ÉСÊý:=(LEFT(A2,FIND(\

´Ó Ó¢ÎĶ̾äÖÐÌáȡÿһ¸öµ¥´Ê:=IFERROR(MID($A2,FIND(\\\

\\ ½«µ¥Î»Îª¡°Ë«¡±Ó롰Ƭ¡±»ìºÏµÄÊýÁ¿»ã×Ü:

\\\

{=SUM(IF(ISNUMBER(FIND(\(\Ƭ\

ÌáÈ¡¹¤×÷±íÃû:=RIGHT(CELL(\ ¸ù ¾Ý²úÆ·¹æ¸ñ¼ÆËã²úÆ·Ìå

»ý:=PRODUCT(LEFT(B2,FIND(\,RIGHT(B2,LEN(B2)-FIND(\

ÌáÈ¡À¨ºÅÖеÄ×Ö·û´®:=IFERROR(MID(A2,FIND(\·Ö ±ðÌáÈ¡³¤¡¢¿í¡¢¸ß:=MID($B2,FIND(\£¨\£© \£¨\ÌáȡѧУÓëÒ½ÔºµØÖ·:{=IF(OR(IFERROR(FIND({\ѧУ\Ò½Ôº\ ¼ÆËãÃÜÂë×Ö·û´®ÖÐ×Ö·û¸ö

Êý:{=COUNT(FIND(CHAR(ROW(65:90)),A2),FIND(CHAR(ROW(97:122)),A2),FIND(ROW(1:10)-1,A2))}

ͨѶ¼µ¥ÁÐתÈý

ÁÐ:{=MID(INDEX($A:$A,SMALL(IF(IFERROR(FIND(C$1,$A$1:$A$15),FALSE),ROW($1:$15),100000),ROW(A1))),LEN(C$1)+1,100)}

½« 15λÉí·ÝÖ¤ºÅÂëÉý¼¶Îª18λ:{=IF(LEN(B2)=18,B2,LEFT(REPLACE(B2,7,,19),17)&

MID(\CT(\

½«²úÆ·ÐͺŹ淶»¯:=IF(MID(A2,5,2)=\ Çó×î´óʱ

¼ä:{=TEXT(MAX(--TEXT(REPLACE(LEFT(A2:A7,7),5,1,RIGHT(A2:A7,2)),\