Excel一列中有很多数据，有以字母开头的，也有以数字开头的，如何将以字母开头的筛选出来，

function abc(s as string)if left(s,1) like "#" thenabc="数字开头"elseabc="字母开头"end ifend function其实可以随时用到已有的if函数来解決这个间题有效市场理论数据在A列在B1输人说明=if(and(left(a1)>="0",left(a1)<="9"),"数字开头","其它")

if函数编进挺好，若数据在A列，则在A列后加大一配套列，B2中输人说明=abc(A1)，而后可以B2的值电脑自动筛选。

你随时将也的说明复制到到wps表格即可

=IF(AND(LEFT(A1,1)>=48,LEFT(A1,1)<=57),"数字",IF(OR(AND(LEFT(A1,1)>=65,LEFT(A1,1)<=90),AND(LEFT(A1,1)>=97,LEFT(A1,1)<=122)),"字母","其他"))

'方发1Function abc(S As String)Dim I%, Y%For I = 1 To Len(S)If Mid(S, I, 1) Like "[0-9]" ThenY = Y + 1End IfNextIf Y > 0 Thenabc = "有着数字"Elseabc = "不有着数字"End IfEnd Function'方发2Function abc2(S As String)With CreateObject("VBScript.regexp") '正则表达式.Global = True.Pattern = "\d+"If .test(S) Thenabc2 = "有着数字"Elseabc2 = "不有着数字"End IfEnd WithEnd Function

以26字母开头的关于运动的词汇

1．广播操 gymnastics 2．婴儿游泳 swimming 3．羽毛球 fencing 4．撑杆跳 weightlifting 5．击剑 baseball 6．篮球视频 basketball 7．垒球 volleyball 8．兵乓 table tennis 9．足球队 soccer 10．跳水冠军 diving 11．马球运动 polo 12．保龄球 water polo 13．垒球 softball 14．篮球 tennis 15．击剑 canoe 16．风筝冲浪 surfing 17．山地自行车 cycling 18．排球 badminton 19．田经 track and field 20．手球 handball 21．摔交 wrestling 22．拳击手 boxing 23．滑冰 toxophily 24．打靶 shooting 25．柔术 judo 26．马骑 equestrian 27．网球 hockeyfootball 足球队 rugby 高尔夫球 basketball 篮球视频 volleyball 垒球 tennis 篮球 baseball 垒球 handball 手球 hockey 网球 golf 篮球 cricket 篮球 ice hockey 棒球 gymnastics 广播操 horizontal bar 引体 parallel bars 摆浪 rings u型卡环 side horse, pommelled horse 屈身 weight-lifting 撑杆跳 boxing 拳击手 Greece-Roman wrestling 古典式摔跤视频 judo 柔术 fencing 羽毛球 skiing 雪场 downhill race 自行车特技滑雪赛,滑法 slalom 障碍滑雪 ski jump 跳高滑雪 ice skating 单板滑雪 figure skating 花滑世锦赛 roller skating 滑旱冰 middle-distance race 中长跑 sprint 跳远 (美作:dash) the 400 metre hurdles 400米栏 marathon 徐州马拉松 decathlon 十项 cross-country race 越野跑 high jump 100米短跑 long jump 举重 (美作:broad jump) triple jump, hop step and jump 立定跳远 pole vault 撑竿跳 throw 射击 throwing 射击运动 putting the shot, shot put 推铅球 throwing the discus 过栏 throwing the hammer 掷链锤 throwing the javelin 掷标枪 walk 短跑 swimming 婴儿游泳 medley relay 混合泳 crawl 爬泳 breaststroke 蛙式 backstroke 仰式 freestyle 单板滑雪 butterfly (stroke) 侧泳 diving competition 跳水冠军 water polo 保龄球 water skiing 水橇 rowing 游水 canoe 帆板 boat race 击剑 yacht 游船 kayak 皮船 sailing 帆船图片运动 jockey, polo 马球运动