Åжϵ¥Ôª¸ñÊ××Ö·ûÊÇ·ñΪ×Öĸ:
=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)),\