主题：救教：指定输入数字和显示时间问题

汉字也不能输入？范围太大啦！

egd文件下载

[这个贴子最后由wjq1072在 2012/04/09 05:58pm 第 1 次编辑]

呵呵仅去掉英文字母、汉字。而且对字符数量还有一定的限制！
刷新公式就巨无霸啦！？

Eval("If(Len(Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",1))=1,Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",1)+"" "","""")")+Eval("If(Len(Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",2))=1,Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|

简化一下！
Substitute(Eval("If(Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),"+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@","-1,1)="""","""",Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),"),"|","-1,1)+"" "")+If(Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),")+"-1,1)+"" "")"),"  ","")

加辅助表辅助列吧！似乎不受限制啦，测试一下？
egd文件下载